March 16, 2012 at 9:54 am
i have two tables one in staging and one in destination .both are identical and both have identity column as primary key. so i am trying to use SCD for historical .but the problem i am facing is that in staging and destination there is identity column and i want them to use as Business key.but when i want to select that as Business key in Scd.those columns are not showing up.i dont know why.these are only column which i can select as business key.bcz other columns are of type 2 and type 1.so what should i do?
March 19, 2012 at 1:20 am
I wouldn't use an identity column as a business key.
An identity column doesn't have a "real" value to uniquely identify a row.
For example.
Table A has two records containing client info.
1, John Doe
2, Jane Doe
Table B has also two records regarding the same clients:
1, Jane Doe
2, John Doe
By looking at the identity column, you cannot know if 1 is Jane or John. So it is a very poor choice for a business key.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply