Table of Contents

Search

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

Mappings

Mappings

Configuring the source

Configuring the source

To configure the source, edit the Source transformation.
  1. On the mapping canvas, click the Source transformation.
  2. To specify a name and description for the Source transformation, in the
    Properties
    panel, click
    General
    .
    Transformation names can contain alphanumeric characters and underscores (_). Maximum length is 75 characters.
    The following reserved words cannot be used:
    • AND
    • OR
    • NOT
    • PROC_RESULT
    • SPOUTPUT
    • NULL
    • TRUE
    • FALSE
    • DD_INSERT
    • DD_UPDATE
    • DD_DELETE
    • DD_REJECT
    You can enter a description if desired.
    Maximum length is 4000 characters.
  3. Click the
    Source
    tab and configure source details, query options, and advanced properties.
    Source details, query options, and advanced properties vary based on the connection type. For more information, see the help for the appropriate connector.
    In the source details, select the source connection and source object. For some connection types, you can select multiple source objects.
    If your organization administrator has configured Enterprise Data Catalog integration properties and you've added objects to the mapping from the
    Data Catalog
    page, you can select the source object from the
    Inventory
    panel. The
    Inventory
    panel isn't available in mappings in SQL ELT mode.
    You can also configure parameters for the source connection and source object.
    In advanced mode, you can add an intelligent structure model to the Source transformation for some source types that use an Amazon S3 or Microsoft Azure Data Lake connection. You must create the model before you can add it to the mapping. For more information about intelligent structure models, see
    Components
    .
  4. To configure a source filter or sort options, expand
    Query Options
    . Click
    Configure
    to configure a filter or sort option.
  5. Click the
    Fields
    tab to add or remove source fields, to update field metadata, or to synchronize fields with the source.
    You can't update field metadata for mappings in SQL ELT mode.
  6. To save your changes and continue, click
    Save
    .

0 COMMENTS

We’d like to hear from you!