IICS | Incremental Load with Time Period using Parameter file
Benefits
1. Overhead in ETL process is reduced
2. Exception raised reduced since required data alone considered.
3. Accuracy of historical data for the given period of time tracked easily.
Implementation
1. Mapping
1. Source [EMP_INC]
1. Aggregator to get Max Modified Date
2. Expression to get date as string
3. Target to write into CSV file. — inc_load.txt
2. Target [T_EMP_INC] to write required data alone based on filtration.
2. Session [Task]
1. Input Parameter —$$DateFilt
2. Parameter File
1. Directory — c:\Program Files\Informatica Cloud Secure Agent\TargetFiles
2. File — inc_load.param
3. Advance Options
1. Post-processing Commands — c:\Program Files\Informatica Cloud Secure Agent\TargetFiles\copyf.bat
