Managing Master Data with webMethods OneData : webMethods OneData Consolidation MDM Guide : Data Interchange Mappings : Defining Interchange Mappings from the Consolidation (Staging) Object to a Gold Object
Defining Interchange Mappings from the Consolidation (Staging) Object to a Gold Object
Use the following procedure to define an interchange mapping to populate data from Consolidation (Staging) object, CDI_StagingObject, to the Gold Object, CDI_GoldObject.
1. On the Menu toolbar, click Data Interchange > Configuration > Interchange Mapping.
2. Click Add New Mapping.
3. Define the mapping details as follows:
a. In the Interchange Mapping Source Information, define the following fields:
Field
Description
Mapping Type
Remote Database
Connection
STG [TRILLIUM_STG]
Schema
TRILLIUM_STG
Entity
CDI_STAGINGTABLE
b. In Object Mapping, Object List, select the data object, select CDI_GoldObject.
c. Click Next.
4. Assign an alternate primary key if required. Click Next.
5. Complete the Profile Name and Profile Description and map the source and destination cleansing attributes. Set Window Key from the staging object to the corresponding attribute in the Gold object.
6. Click Save.
7. To view the data in the tables, click the shortcut on the Command toolbar, Go To Data Manager.
Copyright © 2011-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback