Data Transformation Engine Design Studio Tutorial

Chapter 13 - Mapping Multiple Files to One File Using Ellipses
Design Studio Tutorial
239
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.txt detail input file is sorted to correspond with the data in the header
file. The first header record goes with the first set of detail records, the second
header record goes with the second set of detail records, and so on.
The input data is shown below. The arrows indicate how each Header Record
corresponds to a particular set of Detail Records:
You want the output data to look like this:
4500 PO#144 Jul-26-97
aa045,10
aa097,25
7000 PO#175 Oct-04-97
aa533,100
aa022,40
aa045,15
4500 PO#100 May-14-97
aa011,10
Using Ellipses
When the Use ellipses option is enabled, object names used in component rules
(Type Designer) and map rules (Map Designer) are abbreviated to the shortest
unique object name. Some object names may not include ellipses, because the
shortest unique name is the entire name.
Note The ellipses appear in component rules in the Type Designer group window, and in
map rules in the Map Designer.