Data Transformation Engine Design Studio Tutorial

Chapter 14 - Detail Records Not Sorted by PO Scenario
Design Studio Tutorial
251
Icon File type Name Description
Text file PO2.txt Output data file of details and
associated header records.
Map
source file
RandomDetails.mms Map source file containing the
RandomFiles executable
map.
Compiled
map file
RandomDetails.mmc Compiled map file that
generates a list of PO from
randomly ordered detail and
header record input files.
Type tree
analysis
message
file
*.dbe Type analysis message
generated from the type tree
analysis.
Map build
analysis
results file
*.mme Map build analysis results file
generated from the build
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.
Note The Tools > Options > Rule Bar > Use Ellipses option is disabled in the
example map rules shown in this chapter. Disable or enable this option as you
prefer.
Scenario
You have the detail records and header records in two input files. The order of the
records in the files is random.
Note The Detail.txt detail input file is not sorted to correspond with the data in the
header file.