We are trying to create XDM Schema Design for the following data:
Table A: Contact_details
Table B: Account_details
Relation between both the tables:
One person from Table A can have multiple accounts in Table B. It is basically a one-to-many mapping between these 2 tables.
We are trying to create a complete profile of a person with all the details corresponding to their accounts. We tried creating both the tables as Profile class as below:
Table A: Profile Class
Identities: PersonID --> person_id
Table B: Profile Class
AccountID --> account_id
PersonID --> person_id
The profiles were created but didn't have all the information needed. Is there any other way to design XDM Schema for this type of data ?
@Vamsik Create one Profile Schema with Person ID as the primary identity and Account ID as the secondary identity, If you are creating profiles, you can ingest both the tables into one schema itself, it doesn't matter even if one person ID has multiple account IDs. In profile, you can see that one personID has 2 - 3 account IDs
Thanks for the reply @VaniBhemarasetty You are right, we are able to see that one personID has 2-3 account IDs, but we are not able to view the data corresponding to all those 2-3 account IDs, like for example say we want account_type for all the 2-3 account ID's. We are able to see only one account_type value in the attribute section of the profile. Is there any workaround for this ?
@Vamsik You can run SQL queries in AEP for that 2-3 IDs and see all the records. Here is the documentation on Query services