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.