IICS | Slowly Changing Dimension 2 - Part 1 | #informatica

Slowly Changing Dimension #2
1. From above being said, this can be categorized further into
1. Slow changing Dimension 1 - No history maintained
2. Slow changing Dimension 2 - Full History maintained (row level history + current/active record)
3. Slow changing Dimension 3 - Partial History maintained (column level history)
2. Today we will discuss about SCD2 / Date type…
3. Mapping Implementation
1. Source (EMP)
2. Lookup (DIM_EMP_SCD2_DATE)
3. Expression (EMP/DIM_EMP_SCD2_DATE)
4. Router
1. New Record (Insert)
2. Change Record (Update/Insert)
1. Update - Data Driven
2. Insert - Active record insertion
5. Target (DIM_EMP_SCD2_DATE)
1. New Record
2. Change Record
1. Update current record
2. Insert active record