May 29, 2012 at 12:55 am
This question is about business intelligence with sql server 2008 R2.
If you have a person named Jim Brown with his birthdate and social security number (SSN) being located in three different source system.
Do you use surrogate key that should contain Jim's birthday and SSN after you have merged three data row into single one/row in the ETL phase?
May 29, 2012 at 8:09 am
I would say yes, but it is also generally a good idea to maintain whatever natural keys there are that can join those three rows in the first place. Surrogate keys are most useful for tracking slowly changing dimensions.
June 4, 2012 at 11:43 pm
You may want to look into a master data solution.
June 10, 2012 at 2:25 pm
master data solution?
June 10, 2012 at 2:31 pm
Where can I find information about it based on best practice?
June 11, 2012 at 6:01 pm
There's plenty of information on google. I think Kimball touches on it.
Here's one article that looked promising:
Master Data Services is microsofts product, their information can be found here: http://www.microsoft.com/sqlserver/en/us/solutions-technologies/enterprise-information-management/master-data-management.aspx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply