Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
237
Chapter 13 - Mapping Multiple Files
to One File
This chapter defines how to map two input files into one output file.
Objectives
This chapter uses two input files to create one output file.
By completing the exercises for Chapter 13, you will learn how to:
♦ Map two input files (one header and one detail file) into one output file.
♦ Use ellipses to shorten object names in component rules.
♦ Use nested functional maps.
Files Used in this Chapter
You will be working in the c:\mercator\tutorial\MyFolder\Ch13 folder. Use
the files provided in Ch13.zip.
Files Provided for Chapter 13
The following table describes the files provided for this chapter.
Icon File type Name Description
Text file Header.txt Input data file containing header
records.
Text file Detail.txt Input data file containing detail
records in sets by PO.
Type tree TwoFiles.mtt Type tree describing both files of
the input data (file of header
records and file of detail records)
and the output data (file of
purchase orders).