Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

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

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
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database: Flat File
Operating System:
Other Software:
Attachments
Last Modified Date:5/16/2011 4:06 AMID:31085
People who viewed this also viewed

Feedback

Did this KB document help you?



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