Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.0
  3. Part 2: Version 10.2.2
  4. Part 3: Version 10.2.1
  5. Part 4: Version 10.2
  6. Part 5: Version 10.1.1
  7. Part 6: Version 10.1

PowerExchange for Snowflake

PowerExchange for Snowflake

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
    Create Target
    option.
  • 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
    EnableSDKDecimal38
    custom flag in the Data Integration Service properties.
For more information, see the
Informatica 10.4.0 PowerExchange for Snowflake User Guide
.


Updated September 25, 2020