User Guide : Designing and Executing Map : Creating a Map Using New Map Wizard : Creating a Map With Joins Using Map Wizard
 
Share this page             
Creating a Map With Joins Using Map Wizard
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 /download/attachments/24975419/ProjectExplorer_New_Icon.png?version=1&modificationDate=1487964007993&api=v2 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 connection 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 connection 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 Source Data.
The Confirm Source Data screen is displayed.
5. 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.
6. 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.
7. Select Produce Distinct Rows.
8. 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.
9. Click Next.
The Define Target screen is displayed.
10. 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 connection 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.
11. 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)
12. Click Next.
The Target Field Mapping screen is displayed.
13. 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.
14. Click Next.
The Record and BeforeTransformation Event Options screen is displayed.
The record events are added automatically. You can add additional map events on the Mapping tab.
15. In case of multimode target connectors, in the Table Initialization Options section, select the Add BeforeTransformation Map Event option and then select any of the following:
Drop/Create Table
Truncate Table
16. Click Finish.
The map opens in the Map Editor. You can add or update any of the source, target, mapping, and configuration settings.