Im playing with MDS to assess usefulness for my current company. I have been learning the basics but have some questions about how it stores relational data.
Scenario:
Current system has a Client Table. The client table has a lot of columns, but for address it has 3 columuns, Address_Home, Address_Work, Address_Delivery. These are integers, and store a key thats used to look up the address in an Address Table.
In master data services:
1. how would you link the client entity to the address entity in this scenario?
2. is the only way to link these two entities via the subscription views, & ensuring my data is correct when entering it via etl?