Exasol Connector

Exasol Connector

Mapping example

Mapping example

You can create a mapping and then use the mapping in a mapping task
Perform the following steps to create a mapping task:
  1. Select
    Data Integration
    from the menu.
    The Data Integration Home page appears.
  2. To create a mapping, click
    New
    and then in the
    New Asset
    dialog box, click
    Mapping
    .
  3. Click
    Create
    .
    The Mapping Designer appears with a new mapping displayed in the mapping canvas.
  4. In the
    Properties
    panel, enter the mapping name and select the location you want the mapping to reside in, or use the default location.
  5. On the mapping canvas, click the Source transformation to select it.
  6. In the
    Properties
    panel, click
    General
    and enter a name for the Source transformation.
  7. Click
    Source
    and configure the source properties and advanced source properties.
  8. To view the source fields and field metadata, click the
    Fields
    tab.
  9. To save the mapping and continue, click
    Save
    .
  10. On the mapping canvas, click the Target transformation to select it.
  11. In the
    Properties
    panel, click
    General
    and enter a name for the Target transformation.
  12. Click
    Target
    and configure the target properties and advanced target properties:
  13. In the
    Field Mapping
    tab, map the incoming fields to the target fields. You can manually map an incoming field to a target field or automatically map fields based on the field names. If you entered a connection parameter, you must select
    Automatic
    as the field map option to be able to validate the mapping.
  14. Save and run the mapping.
    After you validate the mapping, you can use the mapping to create a mapping task.