Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(5 Ratings)
facebook Twitter
Print Bookmark Alert me when this article is updated


MAPPING TEMPLATE: Splitting a flat file using a Transaction Control transformation and the filename port

This mapping uses the Transaction Control transformation and the filename port to create a new file for each group of records in the source file.

Iconized view of the mapping:

The mapping contains the following transformations:

  • Sorter Transformation
  • Expression Transformation
  • Transaction Transformation

Sorter Transformation

The Sorter contains the following ports:

Expression Transformation

The Expression transformation contains the following ports:

This transformation contains 2 variable ports to store and retrieve the previous value of the input port.
The variable ports must be placed in the same order as seen in the attached mapping.

Transaction Control

The Transaction Control transformation Properties are configured as follows:

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database: Flat File
Operating System:
Other Software:
Last Modified Date:5/16/2011 4:06 AMID:31085
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)