IICS | Incremental Data Load - simplified version
1. Refer my earlier video — • IICS | Incremental Data Load using St...
2. Mapping Implementation
1. Define Mapping variable - $$max_hire_date
2. Source/Source Qualifier [EMP] Defined query to filter $$max_hire_date
3. Expression transformation — SETMAXVARIABLE($$max_hire_date,hiredate)
4. Target - [T_EMP]