Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5
  3. Part 2: Versions 10.4.1 - 10.4.1.3
  4. Part 3: Versions 10.4 - 10.4.0.2
  5. Part 4: Versions 10.2.2 - 10.2.2 HotFix 1
  6. Part 5: Version 10.2.1
  7. Part 6: Version 10.2 - 10.2 HotFix 2

What's New and Changed

What's New and Changed

PowerExchange for Microsoft Azure SQL Data Warehouse

PowerExchange for Microsoft Azure SQL Data Warehouse

Effective in version 10.2.1, PowerExchange for Microsoft Azure SQL Data Warehouse includes the following features:
  • You can run mappings on the Spark engine.
  • You can configure key range partitioning when you read data from Microsoft Azure SQL Data Warehouse objects.
  • You can override the SQL query and define constraints when you read data from a Microsoft Azure SQL Data Warehouse object.
  • You can configure pre-SQL and post-SQL queries for source and target objects in a mapping.
  • You can configure the native expression filter for the source data object operation.
  • You can perform update, upsert, and delete operations against Microsoft Azure SQL Data Warehouse tables.
  • You can configure a cached lookup operation to cache the lookup table on the Spark engine and an uncached lookup operation in the native environment.
For more information, see the
Informatica PowerExchange for Microsoft Azure SQL Data Warehouse 10.2.1 User Guide
.

0 COMMENTS

We’d like to hear from you!