Surrogate Keys in ODS and Dimension

View previous topic View next topic Go down

Surrogate Keys in ODS and Dimension

Post  PugMaster on Wed Mar 26, 2014 6:28 am

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

PugMaster

Posts : 21
Join date : 2010-07-07

View user profile

Back to top Go down

Re: Surrogate Keys in ODS and Dimension

Post  ngalemmo on Wed Mar 26, 2014 7:23 am

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...
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Surrogate Keys in ODS and Dimension

Post  Jeff Smith on Wed Mar 26, 2014 10:26 am

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.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Surrogate Keys in ODS and Dimension

Post  ngalemmo on Wed Mar 26, 2014 11:47 am

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

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Surrogate Keys in ODS and Dimension

Post  PugMaster on Thu Mar 27, 2014 3:56 am

Ok, that does make sense, Many thanks.

PugMaster

Posts : 21
Join date : 2010-07-07

View user profile

Back to top Go down

Re: Surrogate Keys in ODS and Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum