Data Transformation Engine Type Designer Reference Guide
Chapter 2 - Type Designer Basics Item Window
Item Window
From the item window you can enter restrictions for item types. The viewable
columns in the item window will differ depending on the item properties. Value,
Character, and Range are the restriction options available.
The restrictions of an item type are the values accepted as valid data objects or
rejected as invalid data objects. Defining restrictions for an item type limits the
valid values of that item to a specific set. For example, the item type Department
might have a limited set of valid values, which could be individual department
abbreviations. These valid departments (for example, Dev, Sal, and so on) are
restrictions for the Department item type that would be listed in the Include
column. Any invalid departments would be listed in the Exclude column.
Insert the restrictions in the appropriate column.
The columns in the item window can be resized by dragging
(the splitter) at
the top of the grid as shown below: