Data Transformation Engine Design Studio Tutorial

Chapter 14 - Detail Records Not Sorted by PO RandomDetails.mtt Type Tree
Design Studio Tutorial
252
Each header record includes a customer number, an account number, a purchase
order number, and a date. You also have a detail file made up of detail records.
The detail records include a purchase order number, an item ID, a quantity, and a
unit price.
You need to create an output file made up of purchase orders. Each PO has a
header and a set of details.
The detail file is not organized into sets of detail records. For example, the detail
records for purchase order number 144 are scattered throughout the file.
The randomly sorted RandomDetails.txt input data file looks like:
175 aa533 100 2.35
175 aa045 15 3.70
100 aa011 10 6.90
144 aa097 25 4.32
175 aa022 40 2.25
144 aa045 10 5.60
RandomDetails.mtt Type Tree
The RandomDetails.txt input data file is described by the Detail File Input
Data group type in the RandomDetails.mtt type tree.
Using the Map Designer
Create the TwoRandomFiles.mms map source file.
Create the RandomDetails executable map.