User Guide > Designing and Executing Map > Creating a Map Using New Map Wizard > Creating a Map Without Joins Using Map Wizard
Was this helpful?
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 /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. 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 source data is incorrect, click Back and reconfigure the connection.
5. Click Next.
The Define Target screen is displayed.
6. 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.
c. If you have selected a single mode target connector, then the Target Tables screen is displayed. You can specify a new table or select an existing tables and click Next.
7. 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 (this option allows you to specify External Schema by clicking Browse)
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.
8. 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.
9. Map the target fields.
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 also change this information later on the Mapping tab.
10. 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.
11. 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: 02/09/2024