Hi,
I am trying to load a Dimension table which has a mixture of Type 1 and Type 2 columns in it. The data population is working fine as expected when I use the SCD stage. But I am wondering if there is a way to populate Record_Insert_Date and Record_Update_Date in this table based on if a record is inserted(type 2) or updated(type 1).
I could use the Current_Indicator = 'Y' column to populate the Rec_Ins_dt for new records based on Type 2. But how can I update the Rec_Upd_Dt column for Type 1 cols?
Capture Record Insert Date and Record Update Date in SCD Sta
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 34
- Joined: Thu Aug 28, 2014 8:48 pm
- Location: United States
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 34
- Joined: Thu Aug 28, 2014 8:48 pm
- Location: United States