Defining Consolidation Gold Objects for a Multiple Gold Model Project
To define a Consolidation Gold object for a multiple Gold model project
1. Create two data objects: one to represent master information (MASTER) and the second one to represent detail (DETAIL) information.
The MASTER table should contain columns representing the cleansed master data from the Consolidation object, that is, name, email, phone number, and such information. The DETAIL table should contain columns representing the cleansed address or other details from the Consolidation object.
You can define other custom columns per your requirements in order to bring the information from the Consolidation object to Gold object. Windowkey columns should be present in both the MASTER and DETAIL tables. webMethods OneData support only one MASTER to many DETAIL table mappings (one-to-one mapping). For example, in the case of a single person having multiple addresses.
For details on how to create a data object, see Implementing webMethods OneData.
2. Add a column (for example, masterId) in the DETAIL table, and define a foreign key from the DETAIL table to the MASTER table.
For details on how to create and use foreign keys, see Implementing webMethods OneData.
3. Set the object qualifier Consolidation Gold Object in the DETAIL table.
4. In the staging schema, create a view which holds all the columns from both the MASTER and DETAIL tables as an SQL JOIN on the foreign key column.
Example:
CREATE OR REPLACE FORCE VIEW "GOLDVIEW" () AS
SELECT ()
FROM goldmaster a,
golddetail b
WHERE b.masterid = a.masterid;
Note:
The Base object must be set as the DETAIL table.
5. Using the Update Schema functionality, bring the view as a data object to webMethods OneData.
For details on how to use Update Schema, see Implementing webMethods OneData.
6. Create a conceptual object with the master Gold object as the top object.
For details on how to create a conceptual object, see Implementing webMethods OneData.