Creating a Map Without Joins Using Map Wizard
To create a map without 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. Specify the source connection details:
a. In the Source Connection section, 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.
Note: Join connection section is used when two sources are required. For more information, see Creating a Map With Joins Using Map Wizard.
4. Verify the source data. If incorrect, click Back and reconfigure the connection. If the data is correct, click Next.
The Define Target screen is displayed.
5. 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.
If you have selected a single mode target connector, then the Target Tables screen is displayed. You can specify a new table or select existing tables and click Next.
6. In the Target Schema screen, 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)
If you have selected multiple tables, then by default the Use existing schema option is selected and you cannot change this.
7. Click Next.
If you have selected a multimode target connector, then the Multimode Operations screen is displayed. In this screen:
a. Confirm or change the operations for each table or object.
b. Set the keys for the table operations (delete, update, or upsert). You can change this information later in Mapping tab > Advanced View > All Record Instances for this target.
c. After providing the multimode operations, click Next.
The Target Field Mapping screen is displayed.
8. Set the target field mapping. Most of the fields are automatically mapped. You can map the fields by dragging and dropping source fields into the target field Expression column or click on the target field to build an expression. You can add, delete, and sort fields. For details information about mapping fields, see Mapping Target from Source Data.
You can change this later on the Mapping tab.
9. 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.
10. 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
11. Click Finish.
The map opens in the Map Editor. You can add or update any of the source, target, mapping, and configuration settings.
Last modified date: 02/01/2024