Data Transformation Engine Design Studio Tutorial

Chapter 19 - Incrementing Output Data Scenario
Design Studio Tutorial
285
Icon File type Name Description
Compiled
map file
ExecutableUsingINDEX.mmc Compiled map file that
generates the
IndexedOutput.txt
file.
Text file IndexedOutput.txt Output data file that
contains indexed
purchase orders with a
header record, multiple
detail records, and a
trailer record.
Map build
analysis
results file
*.mme Map build analysis
results file generated
from the build process.
Map
source
options file
*.mopt Map options file created
automatically during
the Save process.
Backup
type tree
and map
files
*.bak Backup type tree files
and map source files
are created
automatically during
the Save process.
Copies of the files created during the exercises are provided for all chapters in the
Tutorials\Solutions folder. The structure and use of these files is described in
the Design Studio Tutorial Solutions section on page 18.
Scenario
You have a Header file and a Detail file. These files are to be mapped to a PO
file. In the header of each PO in the output, there is a field whose value
increments by one for each PO. In the first PO, it has the value 1; in the second
PO, it has the value 2; and so on.
The Increment map source file contains three maps using three different
methods of incrementing output.