Best way to create DataMart from multiple external systems?

Question

I am at the planning stage of creating SQL Server DataMart for contact information and mail / email / SMS history. Each piece of data is in a different external system. Because of this, email addresses do not have account numbers, and SMS phone numbers do not have email addresses, etc. In other words, there is no shared primary key. Some data overlap, but I can do nothing but save the most complete version when duplicates occur.

Is there a best practice for creating a DataMart with this data? Would it be acceptable practice to create a key table with a column for each foreign key? Then, a unique primary identifier can be assigned to bind this to other DataMart tables.

Looking for ideas / suggestions for approaches that I may not have thought of yet.

Thank.

Answer 1

The email address or phone number itself sounds like a suitable business key. Typically, an “intermediate” database is used to load data from multiple sources, and then surrogate keys and other conversions are assigned.

? , - . BI/ , .

Answer 2

:

http://en.wikipedia.org/wiki/Extract,_transform,_load#Dealing_with_keys

Answer 3

, - , , . (, , ), ( " /​​// 42,5 8000 ! W00t!" ). " ", , -. , - ( -?) , , . , , .

, , - , "datamart" - , , , " , !"

, , , , , . , ( " , ?" ). , , , ( , ) , , , - ... dportas, ;)