SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,637 questions
Can MDS, DQS and SSIS be used to Consolidate Address records from 7 source systems into one Golden Record?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Greenberg, Adam
1
Reputation point
I have 7 source systems which contain details about the stores of a company. Each store has some core information (address, phone, etc) as well as source-system specific data (manager, tax ID number, etc).
I know that I can import the data from all 7 systems, but how can I make manual or programmatic decisions about which data to keep for a master record, and then let the source systems know what data they need to change?
Are these tools appropriate for this, or are their other purpose-built tools for this?
I am imagining a master row with each of the source system rows grouped underneath it and I can select one piece of surviving data for each field. Do these tools have this concept?
Thank you