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?