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

Targets in mappings in SQL ELT mode

Targets in mappings in SQL ELT mode

Targets in mappings in SQL ELT mode can behave differently than targets in other types of mappings.
The targets can behave differently in the following ways:
  • When you create a mapping in SQL ELT mode, you choose the target connection first.
  • By default,
    Data Integration
    displays the native data type, native precision, and native scale on the
    Fields
    tab instead of the Informatica transformation data type, precision, and scale. You can display the transformation data type, precision, and scale by right clicking the header row and choosing the properties to display.
  • You change the target connection in the mapping properties. In the Target transformation, the target connection is read-only.
  • If you add multiple targets to the mapping, all targets must use the same target connection or connection parameter. If you change the target connection, the Mapping Designer updates all targets in the mapping to use the new connection.
There might be other behavior differences for targets based on the connector type. For more information, see the appropriate connector guide.

0 COMMENTS

We’d like to hear from you!