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

Rules and guidelines for mapping configuration

Rules and guidelines for mapping configuration

Use the following rules and guidelines when you configure a mapping:
  • A mapping does not need a Source transformation if it includes a Mapplet transformation and the mapplet includes a source.
  • If it's not a mapping in SQL ELT mode, you
    can configure multiple branches within the data flow. If you create more than one data flow, configure the flow run order.
  • Connect all transformations to the data flow.
  • You can merge multiple upstream branches through a passive transformation only when all transformations in the branches are passive.
  • When you rename fields, update conditions and expressions that use the fields. Conditions and expressions, such as a Lookup condition or expression in an Expression transformation, do not inherit field name changes.
  • To use a connection parameter and a specific object, use a connection and object in the mapping. When the mapping is complete, you can replace the connection with a parameter.
  • When you use a parameter for an object, use parameters for all conditions or field mappings in the data flow that use fields from the object.
  • You can copy and paste multiple transformations at once between the following open assets:
    • Between mappings
    • Between mapplets
    • From a mapping to a mapplet
    When you paste a transformation into another asset, all transformation attributes except parameter values are copied to the asset.

0 COMMENTS

We’d like to hear from you!