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

Start a new topic

Answered

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

Subramani SIVARATHNAM

started a topic 3 months ago

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

Guillaume RIVOLLIER said 3 months ago

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 Comments

Subramani SIVARATHNAM

said 3 months ago

Any Response to this is really appreciated/

Guillaume RIVOLLIER