What type of sources can be partitioned in informatica

PowerCenter Rename Saved Search. Overwrite saved search. Save Cancel. Confirm Deletion. OK Cancel. Table of Contents Search. No Results. Change the Reader Step 3. Reorder the Generated Ports Step 5. Configure the Read Transformations Step 2. Configure the Joiner Transformation Step 3.

Configure the Aggregator Transformation Step 4. Configure the Write Transformation Step 5. Create and Configure a Run-time Link Step 6. Validate and Run the Mapping Step 7. Validate and Save the Mapping Step 6. Back Next. Partitioned Flat File Sources. When a mapping that is enabled for partitioning reads from a flat file source, the Data Integration Service can use multiple threads to read the file source.

The Data Integration Service can create partitions for the following flat file source types:. Direct file. If you configure a session for multi-threaded reading, and the Integration Service cannot create multiple threads to a file source, it writes a message to the session log and reads the source with one thread. When the Integration Service uses multiple threads to read a source file, it may not read the rows in the file sequentially. If sort order is important, configure the session to read the file with a single thread.

For example, sort order may be important if the mapping contains a sorted Joiner transformation and the file source is the sort origin. You can also use a combination of direct and indirect files to balance the load. Session performance for multi-threaded reading is optimal with large source files. The load may be unbalanced if the amount of input data is small.

You cannot use a command for a file source if the command generates source data and the session is configured to run on a grid or is configured with the resume from the last checkpoint recovery strategy.

Partitioning File Sources. Updated May 02, Download Guide. Send Feedback.