Archives of the TeradataForum
Message Posted: Fri, 11 Oct 2002 @ 14:08:10 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|