Can we design Datawarehouse without a surrogate key in dimension table? if yes how will it affect the performance?
Surrogate Key
(3 posts) (3 voices)-
vikash4all
MemberHi Surrogate key is nothing but a unique integer column tat will define each element of the dimension uniquely.
If you dont want to use SR key then well and good, if you have any other column of integer type that is uniquely defining each record of the dimension i.e. may be primary key column.As Integer and Bigint datatypes are best as per performance basis, so its good to use it.
Posted 1 year ago # -
thomasb4all
Member@vikash, its very true that a surrogate key in a database is a unique identifier and because that only it is used as a key column in the dimension.
Theoretically any unique column in the dimension can play the role of a surrogate key.
Because we generally populate fact with only numeric values, hence keeping the unique identifier column in the dimension is mostly suggested.Posted 1 year ago #
Reply
You must log in to post.
