Hi，I have some problems with the ETL process. For example, the database is focusing on an event, for example, delivery. If there is a table containing data for multiple roles, including parents, children, how to map these data into CDM? How to deal with the situation where multiple ID values coexist in a table? Thanks.
Each Person is separate. The mother, the child, the father, all have a record in PERSON. They are then connected through FACT_RELATIONSHIP:
Hope this helps.
CR