Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
249
Chapter 14 - Detail Records Not
Sorted by PO
In Chapter 13, the detail records in the Detail.txt file were in the same order as
the corresponding header records in the Header.txt file.
Your data may be in random order and not be sorted or organized into sets.
Objectives
This exercise associates randomly ordered detail records with the correct header
record.
By completing the exercises for Chapter 14, you will learn how to:
♦ Associate randomly sorted detail records with header records.
♦ Use the
EXTRACT function to extract a detail record from the detail file when
the PO# of the detail record is equal to the PO# of the header record.
♦ Close all run results windows at the same time.
Files Used in this Chapter
You will be working in the c:\mercator\tutorial\MyFolder\Ch14 folder. Use
the files provided in Ch14.zip.
Files Provided for Chapter 14
The following table describes the files provided for this chapter.
Icon File type Name Description
Text file RandomDetails.txt Input data file containing
multiple detail records, sorted in
random order.
Text file Header.txt Input data file containing header
records.