What's New and Changed

Back Next

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