Brandie,

my experience with the SCD is that you should see the business keys as columns which, when they change , require a new record. Also the business key should be...

Maybe a too simple solution and you have been that way, but I see as a workaround :

1) lookup on

the DataStagingSource.NaturalKey = DataWarehouseDimension.NaturalKey

and include in the lookup the...