Skip to Content
0
Former Member
Oct 26, 2005 at 10:53 PM

Load Time Independant Object to Time Dependant Object

21 Views

This is a common situation in a data warehousing environment were the time dependacy of an object (master data or Hierarchy) is not maintained in the source system but needs to be maintained in the DW system.

Lot other ETL tools automatically provide the SCD type-2 functionaly which automatically makes the previous record in the DW system as a old record and update the "SCD to-date" field either system date - 1(day or sec) and inserts a new record with "SCD From-Date" as system date when ever an attribute that we are tracking for "SCD type-2" changes value which is different from the value that is present in the DW.

Can we achieve the same in BW? Please let me know.