Surrogate Keys in ODS and Dimension

Hi

I am in the process of building a Dimensional database on top of an ODS database. The ODS is used for support operations and has a surrogate key and business key. The dimensional database is required for analytics.

My question is should I carry both the ODS Surrogate key and business key over to the Dimensional database or just one of them and if so which?

Kind Regards
Paul

Bring the business key into the DW and generate its own surrogate key. You don't want ODS surrogate keys because they are useless without the ODS. If the ODS is dropped or replaced in the future you will be in a world of hurt...

I don't think it hurts to bring the ODS surrogate Key into the Dimension, but you wouldn't use it as the surrogate key of the dimension.

Yes, if it is simply an attribute, there is no problem. It should not serve as a key in the DW.

Ok, that does make sense, Many thanks.