Any Response to this is really appreciated/
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
Subramani SIVARATHNAM
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.