Data Transformation Engine Design Studio Tutorial

Chapter 1 - Mapping Basics Scenario
Design Studio Tutorial
22
In the Contact.mtt type tree:
♦ The input data is a file that consists of a single contact record. The data object
that represents the file containing the contact record is ContactFile.
♦ The input data is also a contact record consisting of many data fields delimited
by commas. The data object that represents the contact record is Contact.
Adams,James,ABC Co.,29 Frankford Rd,Bloomington,IL,60525,708,3525555
First
Name
Company Street
State
City
Zip code Phone
Area
code
Contact
Last
Name
The Type Designer is the design component used to specify, define, and manage
type definitions. Type trees are maintained and created in the Type Designer,
although type trees can also be created using the Type Tree Maker, the Importer
Wizard in the Type Designer, and the Database Interface Designer.
The type definitions of the Contact record are defined in the Contact.mtt type
tree file. Type definitions define the data in a classification hierarchy and do not
reflect the data structure. The type tree organizes types alphabetically (for
example, AreaCode, City, Company, and so on).
The Contact.mtt type tree
in the Type Designer
defines the data in a
classification hierarchy