How to implement type1 scd and type2 scd both in a single dimension table?
I am fairly new to data services and facing few more challenges. Would you please provide inputs on below:
1.I am trying to implement a dimension table having both scd type1 and type2 column. Now lets say my type 2 column is changed, it gonna create a new row with current flag as 'Y' and will expire the old row with 'N' and the column will have new values in the new row. Now, if TYPE1 column is changed, its jut updates the latest row with current flag as 'Y" and older row with flag 'N" still has older value for type1 column. How can i update all the type 1columns in older rows as well.
2.The effective date for the record is 1/1/1900 and expiration date is 12/31/2050 when i run the load first time.When history is preserved the older record expiration date is set to sysdate and a new record with effective date as sysdate has to be added and the expiration date as 12/31/2050. How to achieve this?
I tried various things but somehow my dates are messed up.