Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery

Mappings

Mappings

Mapping Designer

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.

0 COMMENTS

We’d like to hear from you!