When you use bulk data offload processing, PowerExchange moves the column-level processing to the PowerCenter Integration Service machine that runs the bulk data movement session. For most data sources, PowerExchange can optionally move the filtering of source data to the PowerCenter Integration Service machine.

You can use bulk data offload processing for the following data sources:

You can use bulk data offload processing for the following data targets:

For most data sources, you can use multithreaded processing in bulk data movement sessions that use offload processing. By default, PowerExchange uses a single thread to process bulk data on the PowerCenter Integration Service machine. When you configure multithreaded processing, PowerExchange uses multiple threads to process the bulk data records.