Sources in mappings in SQL ELT mode can behave differently than sources in other types of mappings.
The sources can behave differently in the following ways:
When you create a mapping in SQL ELT mode, you can read data from cloud data lakes and cloud data warehouses within the cloud ecosystem.
For example
, when
you're loading data to Snowflake Data Cloud and
you configure the source connection in the Source transformation, you can choose only an Amazon S3, Azure Data Lake Storage Gen2, or Snowflake Data Cloud connection.
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.
If you add multiple sources to the mapping, all sources use the same source connection or connection parameter. If you change the source connection or connection parameter in one of the sources, the Mapping Designer updates the other sources so that they all use the same connection.
Mappings in SQL ELT mode that read data from a cloud data warehouse always write data to the same cloud data warehouse. Therefore, if the source is a Snowflake cloud data warehouse, it must use the same connection or connection parameter as the target.
If you want to create a connection parameter that is the same as the target type, you need to create the parameter in the mapping properties where you choose the target connection.
For example, if
you're loading data to Snowflake Data Cloud and
you create a connection parameter in the Source transformation, you can set the connection type to Amazon S3 or Azure Data Lake Storage Gen2. If you want to create a Snowflake connection parameter, you need to create the parameter in the mapping properties where you choose the target connection.
If the source and target use the same connection and you change the target connection in the mapping properties, the connection in the source is automatically updated to use the same connection. If the Source transformation uses a different connection, then the source connection doesn't change when you change the target connection.
For example, if you change the
Databricks
connection in the mapping properties, the
Databricks
connection in the source is automatically updated to use the same connection. However, if the Source transformation uses an Amazon S3 or Azure Data Lake Storage Gen2 connection, then the source connection doesn't change when you change the target connection.
There might be other behavior differences for sources based on the connector type. For more information, see the appropriate connector guide.