Slowly Changing Dimension - Type I

Using Lookup Transformation - Dynamic Cache


With a dynamic cache, the Integration Service inserts or updates rows in the cache. When you cache the target table as the lookup source, you can look up values in the cache to determine if the values exist in the target. The Lookup transformation marks rows to insert or update the target.

Final Output -  The Second Table gets updated with the recent record

Table 1 - Application1 - No Primary Key

Table2  - Application2 - App_ID is the Primary Key

LookUp Tranformation - Condition Tab

Lookup Transformation - Properties Tab

Lookup Transformation - Ports Tab

Router - Groups Tab

Router - Ports Tab

Mapping Designing

Update Strategy - Property t/ab

Session Edit

Session Edit