Effective in version 10.4.0, PowerExchange for Snowflake includes the following features:
You can run Snowflake mappings in the Databricks environment.
You can use Snowflake objects as dynamic sources and targets in a mapping.
You can create a Snowflake target using the
You can configure a target schema strategy for a Snowflake target in a mapping. You can choose from the available options to either retain the existing target schema or create a target if it does not exist. You can also specify the target schema strategy options as a parameter value.
You can specify a rejected file name and path in the Snowflake advanced target properties which the Data Integration Service uses to write records that are rejected while writing to the target.
When the ODBC provider type in the Snowflake ODBC connection is Snowflake, you can configure pushdown optimization to push the transformation logic to the Snowflake database.
You can read or write data of Decimal data type of 38-bit precision and scale by configuring the
custom flag in the Data Integration Service properties.
For more information, see the
Informatica 10.4.0 PowerExchange for Snowflake User Guide