Microsoft SQL Server Connector

Back Next

Pass-through partitioning

You can configure pass-through partitioning to optimize the performance of

mapping

tasks when you read data from Microsoft SQL Server sources.

To configure pass-through partitioning, specify a query or filter value for each partition to read data in parallel.

Consider the following rules and guidelines when you run a mapping task enabled for pass-through partitioning to read from Microsoft SQL Server:

When you upsert data in a Microsoft SQL Server target, data discrepancies occur.

Even though you configure a filter in the Source transformation, you can't filter source data.

When you specify an SQL override in a Source transformation, the SQL override statement overrides the SQL query and source filter statements for the configured partitions.

For example, if you specify an SQL query or source filter for five partitions, the SQL override overrides the SQL query and source filter statements for all the five partitions.

Mappings and mapping tasks with Microsoft SQL Server Connector

Processing Unicode characters

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal