How to Split (A Single Golden with multiple Master Golden record into multiple Golden Record based on business Condition
S
Subramani SIVARATHNAM
started a topic
15 minutes 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.
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.