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.

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

.