Mappings

Back Next

Mapping Designer

Use the Mapping Designer to create mappings that you can use in

mapping

tasks.

The following image shows the Mapping Designer:

The Mapping Designer contains the following areas: Properties panel, header, transformation palette, mapping canvas, toolbar, Inventory panel, Parameters panel, and Validation panel.

The following table describes the areas of the Mapping Designer:

Mapping Designer Areas	Description
1. Properties panel	Displays configuration options for the mapping or selected transformation. Different options display based on the transformation type. Includes icons to quickly resize the Properties panel. Use the icons to display the Properties panel, the mapping canvas, or both. You can also manually resize the Properties panel.
2. Header	Displays the following information, buttons, and icons: Mapping name. Mapping status. The status can be either Valid or Invalid. Switch to Advanced button. Use to update the mapping canvas to advanced mode. Save button. Run button. Use to create a test run of the mapping. Undo and redo icons. You can undo and redo actions until you save the mapping. Inventory icon. Displays and hides the Inventory panel. Parameters icon. Displays and hides the Parameters panel. Validation icon. Displays and hides the Validation panel. SQL ELT Query icon. Displays and hides the SQL ELT Query panel. Actions icon. Use to create and save a mapping task or dynamic mapping task based on the mapping, adjust the data flow run order, and set the stored procedure run order. Close icon.
3. Transformation palette	Lists the transformations that you can use in the mapping. To add a transformation, drag the transformation to the mapping canvas.
4. Mapping canvas	The canvas where you configure a mapping. When you create a mapping, a Source transformation and a Target transformation are already on the canvas for you to configure.
5. Toolbar	Displays the following icons and buttons: Recommendation toggle. Turns CLAIRE™ recommendations on or off. Shown when organization CLAIRE recommendation preferences are enabled. Arrange All icon. Arranges the mapping. Delete icon. Deletes the selected transformation or link. Cut. Copy. Paste. Zoom In icon. Increases the size of the mapping. Zoom Out icon. Decreases the size of mapping.
6. Inventory panel	Lists Enterprise Data Catalog objects that you can add to the mapping as sources, targets, or lookup objects. Your organization must have the appropriate licenses in order for you to see the Inventory panel. Objects appear in the inventory when you search for objects on the Data Catalog page, select them in the search results, and add them to the mapping. To delete an object from the inventory, click "X" in the row that contains the object. Displays when you click Inventory . To hide the panel, click Inventory again.
7 . Parameters panel	Lists the parameters in the mapping. You can create, edit, and delete parameters, and see where the mapping uses parameters. Displays when you click Parameters . To hide the panel, click Parameters again.
8 . Validation panel	Lists the transformations in the mapping and displays details about mapping errors. Use to find and correct mapping errors. Displays when you click Validation . To hide the panel, click Validation again.
9 . Bird's Eye View icon	Opens the Bird's Eye View panel which displays an overview of your entire mapping and highlighted field lineage. Use the navigation pane in the panel to scroll the canvas.

For mappings in SQL ELT mode, the Mapping Designer looks slightly different, as shown in the following image:

The Mapping Designer contains the following areas: Properties panel, header, transformation palette, mapping canvas, toolbar, Parameters panel, and Validation panel.

The following table describes the areas of the Mapping Designer for a mapping in SQL ELT mode:

Mapping Designer Areas	Description
1. Properties panel	Displays configuration options for the mapping or selected transformation. Different options display based on the transformation type. Includes icons to quickly resize the Properties panel. Use the icons to display the Properties panel, the mapping canvas, or both. You can also manually resize the Properties panel.
2. Header	Displays the following information, buttons, and icons: Mapping name. "SQL ELT Mode" indicator and icon for the cloud ecosystem. Mapping status. The status can be either Valid or Invalid. Save button. Run button. In SQL ELT mode, the Run button is disabled. To run the mapping, create a mapping task. Undo and redo icons. You can undo and redo actions until you save the mapping. Parameters icon. Displays and hides the Parameters panel. Validation icon. Displays and hides the Validation panel. Actions icon. Use to create and save a mapping task based on the mapping. See Tasks for more information about mapping tasks. Close icon.
3. Transformation palette	Lists the transformations that you can use in the mapping. To add a transformation, drag the transformation to the mapping canvas.
4. Mapping canvas	The canvas where you configure a mapping. When you create a mapping, a Source transformation and a Target transformation are already on the canvas for you to configure.
5. Toolbar	Displays the following icons and buttons: Arrange All icon. Arranges the mapping. Delete icon. Deletes the selected transformation or link. Cut. Copy. Paste. Zoom In icon. Increases the size of the mapping. Zoom Out icon. Decreases the size of mapping.
6. Parameters panel	Lists the parameters in the mapping. You can create, edit, and delete parameters, and see where the mapping uses parameters. Displays when you click Parameters . To hide the panel, click Parameters again.
7. Bird's Eye View icon	Opens the Bird's Eye View panel which displays an overview of your entire mapping and highlighted field lineage. Use the navigation pane in the panel to scroll the canvas.
8. Validation panel	Lists the transformations in the mapping and displays details about mapping errors. Use to find and correct mapping errors. Displays when you click Validation . To hide the panel, click Validation again.