Home Forums Data Warehousing Strategies and Ideas Slowly Changing dimensions Design and ETL Help RE: Slowly Changing dimensions Design and ETL Help
aaa121
SSCertifiable
Points: 5902
More actions
December 30, 2010 at 5:02 am
#1267618
That's quite an interesting approach with your "Version" field Paul. I can imagine that could prove very useful.
You don't mention a "IsRowCurrent" field however, do you derive this at run time when making SCD changes to your Dims?