|
... The Surrogate Key Notice that the DimCustomer dimension includes the CustomerKey column and the CustomerBusKey column. Let’s start with CustomerKey. The CustomerKey column is the dimension’s primary key. In ... the DimCustomer dimension contains the original customer ID, and the CustomerKey column contains the new ID (which is the surrogate ...
Tags:
datamart
ssas
fact and diminsion
warehouse

http://rawbeez.livejournal.com/4272.html
(Cached)
0 links
Published: 1 year, 1 month ago (Wed, 12 Nov 2008 06:55:31 PST); 26 Kb
|