Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.2
  3. Part 2: Version 10.5.1 - 10.5.1.1
  4. Part 3: Versions 10.5 - 10.5.0.1
  5. Part 4: Versions 10.4.1 - 10.4.1.3
  6. Part 5: Versions 10.4 - 10.4.0.2
  7. Part 6: Versions 10.2.2 - 10.2.2 HotFix 1
  8. Part 7: Version 10.2.1
  9. Part 8: Version 10.2 - 10.2 HotFix 2

What's New and Changed (10.5.2)

What's New and Changed (10.5.2)

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
.

0 COMMENTS

We’d like to hear from you!