MRI Software mapping example

1. 1Select Data Integration from the menu.
The Data Integration Home page appears.
2. 2To create a mapping, click New and then in the New Asset dialog box, click Mapping.
3. 3Click Create.
The Mapping Designer appears with a new mapping displayed in the mapping canvas.
4. 4In the Properties panel, enter the mapping name and select the location you want the mapping to reside in, or use the default location.
5. 5On the mapping canvas, click the Source transformation.
1. aIn the Properties panel, click General and enter a name for the Source transformation.
2. bClick Source and select an MRI Software connection to read MRI Software objects.
3. cSelect Single Object as the Source Type.
4. dSelect the MRI Software object for which you want to read the data.
5. eUnder Query Options, configure the filter fields for the MRI Software objects.
Note: The filter is mandatory for certain MRI Software objects. For more information, see Filtering records from MRI Software sources.
6. fTo save the mapping and continue, click Save.
6. 6On the mapping canvas, click the Target transformation.
1. aIn the Properties panel, click General and enter a name for the Source transformation.
2. bClick Target and select a flat file connection to write data to a flat file.
3. cSelect Single Object as the Target Type.
4. dSelect the flat file as the target object.
5. eSelect Insert as the Operation.
Note: You can perform only the insert operation
6. fIn the Field Mapping tab, map the incoming fields to the target fields. You can manually map an incoming field to a target field or automatically map fields based on the field names.
7. 7Save and run the mapping.
After you validate the mapping, you can use the mapping to create a mapping task.