Re: To use or not to use Surrogate Keys in Dimensional Modeling

#1

1) speed...the importance of this depends on your dw volumes...
2) yes it gets a littelere more complicated to build...but necessarily to
maintain...in my opinion
3) and then there are some other business process arguments which you can
learn from this link....(perhaps there is some litterature more up-to-date)

http://www.dbmsmag.com/9805d05.html

\Michael vardinghus

"Steven Wong" <anonymous (AT) discussions (DOT) microsoft.com> skrev i en meddelelse
news:A995C138-A0B2-4060-8ECF-EE7BDBC5CD3E (AT) microsoft (DOT) com...

Quote:

What are the factors to consider on whether to use
surrogate foreign/primary keys in fact/dim tables? Is it
a requirement to use surrogate keys in a data warehouse
environment? It does complicate things more in the ETL
process and maintenance wise by using surrogate keys,
agree or disagree?

Your feedback is certainly appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: To use or not to use Surrogate Keys in Dimensional Modeling

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: To use or not to use Surrogate Keys in Dimensional Modeling - 05-05-2004 , 02:59 PM