I am a little confused with remote keys.
Let say that I am doing a vendor consolidation from two source systems S1 and S2, So I believe that you will be using a remote key to assigned to vendor number(main table entry) and for other lookup table entries. So that when you want distribute the data back to the source systems it would be useful.
1. why am I not using remote keys for all the tables?
2. next we will be doing a centralization scnrio, in that case lets say I have created 10 new vendors in MDM, 6 belongs to S1 and 4 belongs to S2(meaning that I will have to syndicated back these to the respective source systems), In that case how will I know which records have to go to which source system.