Can MDS, DQS and SSIS be used to Consolidate Address records from 7 source systems into one Golden Record?

Greenberg, Adam 1 Reputation point
2022-06-15T17:03:48.763+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,492 questions
No comments
{count} votes