Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Surrogate Keys in ODS and Dimension

3 posters

Go down

Surrogate Keys in ODS and Dimension Empty Surrogate Keys in ODS and Dimension

Post  PugMaster 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

Back to top Go down

Surrogate Keys in ODS and Dimension Empty Re: Surrogate Keys in ODS and Dimension

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

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

http://aginity.com

Back to top Go down

Surrogate Keys in ODS and Dimension Empty Re: Surrogate Keys in ODS and Dimension

Post  Jeff Smith 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

Back to top Go down

Surrogate Keys in ODS and Dimension Empty Re: Surrogate Keys in ODS and Dimension

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

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

http://aginity.com

Back to top Go down

Surrogate Keys in ODS and Dimension Empty Re: Surrogate Keys in ODS and Dimension

Post  PugMaster Thu Mar 27, 2014 3:56 am

Ok, that does make sense, Many thanks.

PugMaster

Posts : 21
Join date : 2010-07-07

Back to top Go down

Surrogate Keys in ODS and Dimension Empty Re: Surrogate Keys in ODS and Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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