Creating a Map With Joins Using Map Wizard
Note: Joining data sources (in the Map Wizard or the Map Editor) can only be done if both the source and the join data contains a single record type.
To create a map with joins using the Map Wizard:
1. Select a DataConnect project and do any of the following:
• Go to File > New > Map.
• Click the arrow in 
and then click Map.
and then click Map.• Right-click on the project and then click New > Map.
The New Map Wizard is displayed.
2. In the Map File Name text box, type a name for the map and click Next.
The Define Sources screen is displayed.
3. In the Source Connection section, specify the first source connection details:
a. Do one of the following:
– From the Choose Connector drop-down list, select a source connector.
– In Or Connection, click Browse and select an existing source connection file.
The connector parts are displayed. Also, the selected connector’s properties are displayed on the right.
b. Specify the required information. For information about the selected connector and its properties, see Map Connectors and for information about the connection details, see Setting Up Source Data.
4. In the Join Connection section, specify the second source connection details:
a. Do one of the following:
– From the Choose Connector drop-down list, select a source connector.
– In Or Connection, click Browse and select an existing source connection file.
The connector parts are displayed. Also, the selected connector’s properties are displayed on the right.
b. Specify the information. For information about the selected connector and its properties, see Map Connectors and for information about the connection details, see Setting Up Source Data.
5. Click Next.
The Confirm Source Data screen is displayed.
6. Verify both source and join data. If incorrect, click Back and reconfigure the source and/or join connection. If the data is correct, click Next.
The Configure Join Options and Keys screen is displayed, where you can configure the properties to join the two data sources.
7. Select the Join Type:
• Full Outer: Returns all records from both sides of join.
• Inner: Returns records identical on both sides of join. Discard unmatched records.
• LeftOuter: Returns all records in source or join on left side, even if no records match on right side.
• RightOuter: Returns all records in source or join on right side, even if no records match on left side.
8. Select Produce Distinct Rows.
9. In Set Join Keys section, specify the columns used as the join keys by dragging and dropping the source keys into the matching target (join) key field expression column.
Note: Since the fields required in a join are specified when the join is created, there is no option to specify the fields after creating the map. However, you must select at least one key.
10. Click Next.
The Define Target screen is displayed.
11. Specify the target connection details:
a. In the Target Connection section, do one of the following:
– From the Choose Connector drop-down list, select a target connector.
– In Or Connection, click Browse and select an existing connection file.
The connector parts are displayed. Also, the selected connector’s properties are displayed on the right.
b. Specify the information and click Next. For information about the selected connector and its properties, see Map Connectors and for information about the connection details, see Setting Up Target Data.
The Target Schema screen is displayed.
12. Choose one of the following option to specify the target schema:
– Use source schema (this option may be disabled if source is hierarchical or multi-record and the target is not)
– Use existing schema (this option may be disabled if the target is a new file or table)
– Use an external schema
– Manually create schema (this option will automatically add one field that can be changed on the Mapping tab)
13. Click Next.
The Target Field Mapping screen is displayed.
14. Set the target field mapping. If source fields are available, then map the fields by dragging and dropping source and join fields into the target field Expression column or click on the target field to build an expression. For information about mapping fields, see Mapping Target from Source Data.
15. Click Next.
The Event Actions screen is displayed.
The record event actions and transformation event actions will be added automatically. You can manage the map events on the Mapping tab.
In case of multimode target connectors, in the Transformation Events and Actions section, select the Add TransformationStarted Map Events option and then select any of the following:
• Drop/Create Table
• Truncate Table
• Append data to Table (no event)
You can manage the transformation events on the Configuration tab.
16. Click Finish.
The map opens in the Map Editor. You can add or update any of the source, target, mapping, and configuration settings from here.
Last modified date: 10/22/2024