IICS | Incremental Data Load using Store Proc Transformation |

Incremental Data Load
1. The reason behind incremental load is to move only required data only alone to be passed on to target system from source system.
2. This in align with day to day operations done by business with regards to new or changes data considered…
3. Mapping Implementation
4. Source/Source Qualifier [EMP]
5. Transformation
1. Mapping variable -- v_max_hiredate
2. Store Procedure [Unconnected] - helps to find max hire date…
3. Expression - connected with SQ and make use of Store Procedure
4. Filter - hire date (greater) o_hiredate
6. Target [T_EMP]
7. Task [Session] created using the Mapping created…
8. Finally, executing above implementation to find out the results as expected…