SCD - Slowly Changing Dimention - Type 1, Type -2 , Type -3 Data Warehouse Concepts

SCD - Slowly Changing Dimention - Type 1, Type -2 , Type -3 Data Warehouse Concepts

If you are using This at ODI we have separate IKM for SCD type -2

Oracle IKM Slowly Changing Dimensions

And Below Properties we need to set for each column.

DataStore=>OLAP Type=> Slowly Changing Dimension.

1) Surrogate Key or Natual Key
2) Overwrite on Change ( No History)
3) Add row on change ( With History as a new record)
4) Starting Timestamp ( Record starting date)
5) Ending Timestamp ( Record Ending date lifetime)
6) Record status flag  ( Records status Active or Inactive (1-Active, 0-Inactive)