Data Transformation Engine Design Studio Tutorial

Chapter 7 - Using Cross-Referenced Data Modifying the Customer.mtt Type Tree
Design Studio Tutorial
155
Field Item Types
The item types for the fields have already been created for you in Customer.mtt.
Region Data
The data is a file you will generate as an output of the Customer map. You want
to generate the region.txt file to contain the zip code and the region for each
record. This data file is delimited with two spaces between fields.
60525 North
60089 West
33321 South
60012 North
19444 West
44444 South
Record Group Type Represents Region Records
Create a group type to represent the region records in the region.txt file. Name
the group type Record.
Properties of Record
♦ The record data is presented sequentially. The Group Subclass = Sequence.
♦ The format of the data relies on syntax to separate components. Each
component can be identified by its position, or by a delimiter in the data. The
Group Subclass > Format = Explicit.
♦ The Format > Component Syntax = Delimited.
♦ Components are separated by two spaces. For the Delimiter > Value,
enter
<SP><SP> or click (browse) and use the Symbols dialog box.