Start a new topic
Discussions xDM xDM - Integration
Answered

How to Split (A Single Golden with multiple Master Golden record into multiple Golden Record based on business Condition

How to Split a Single Golden Record with Multiple Master Golden Records into Multiple Golden Records Based on Business Conditions Using PL/SQL Program?


Our database is PostgreSQL.


**Example:**


- **Golden Record (GD)**: ABC Corp  

- **Master Record 1 (MD1)**: American Broadcast Corporation  

- **Master Record 2 (MD2)**: Albert Book Company  


Our goal is to split the master records as follows:


- **GD1**: American Broadcast Corporation (from MD1)  

- **GD2**: Albert Book Company (from MD2)  


We would like to accomplish this using a PL/SQL script, noting that our database is PostgreSQL.


Best Answer

Hello,


I have moved this topic as it was originally posted in an xDI related forum.


You can take inspiration from the 4th example of this page of the documentation.

This will split the masters into multiple golden records, using the SQL API.


Best regards,

Guillaume R

2 CommentsSorted by Oldest First

Any Response to this is really appreciated/

Answer

Hello,


I have moved this topic as it was originally posted in an xDI related forum.


You can take inspiration from the 4th example of this page of the documentation.

This will split the masters into multiple golden records, using the SQL API.


Best regards,

Guillaume R

Login to post a comment
More topics in xDM - Integration
See all 61 topics
Help Desk Software by Freshdesk