Data Transformation Engine Design Studio Tutorial

Chapter 6 - Using the OR Function with a Lookup File Creating the Preferred Type Tree
Design Studio Tutorial
130
first and define the common properties in the Field properties window. Then
create the Company and ID types created as subtypes of Field. These types
inherit the properties of Field.
The PurchaseDate type can also be created as a subtype of Field, although the
Item Subclass property must be Date.
These item types have Class = Item, Partitioned = No, and the default
Order subtypes = Ascending.
The table below displays the properties of the item types, their interpretations,
minimum content size, and maximum content size.
Type Name Item Subclass Interpret as Min. Size Max. Size
Field Text Character 0
Company Text Character 0
ID Text Character 0
PurchaseDate Date & Time Character
The Field types share common properties. They are:
♦ Subclass = Text
♦ Interpret as = Character
♦ Size (content) > Min = 0
♦ Size (content) > Max = <none>
Note The PurchaseDate item type has a different Item Subclass and no minimum
size.
Creating the Preferred Type Tree
Use the Type Designer to create a type tree that represents the data.
To create a type tree
1 From the File menu, choose New.
A new type tree with the TypeTree1 default name is created.