Archives of the TeradataForum

Message Posted: Fri, 11 Oct 2002 @ 14:08:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I'd like to ask if anyone has any specific ideas regarding the pros and cons of assigning surrogate keys in the DW, as opposed to inheriting your source system natural keys. I realize some of the pros for surrogates, are that you might have some space savings, and you can hide some complexity of the source system keys etc...

I'm specifically thinking of how far to take it - is it a good idea to assign different levels of surrogate keys in each and every instance of parent and child tables and take it multiple levels down? Should you always assign a surrogate when you have multiple sources (with different number of composite natural keys) for the same entity..?

Thanks in advance,

Johannes

	<Prev	Next>		<<First	<Prev	Next>	Last>>