Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
180
Chapter 9 - Data Breaks by Object
Count
Physical characteristics of data include delimiters and established values of fixed
length objects. These physical characteristics are used to determine where data
objects begin and end. If the data has delimiters or is of a fixed length, these
characteristics can be defined in the type properties in the Type Designer. If data
is not of fixed length or it does not contain delimiters, other methods are required
to define a break in the data.
Breaks in data can be also determined when:
The count of a certain object reaches a specific value.
or
When the value of a certain item changes.
Objectives
This exercise uses the first method to define logical breaks in the data.
By completing the exercises for Chapter 9, you will learn how to:
Count objects to determine breaks in the data.
Dock or float the Rule Bar and Navigator window.
Create a new type tree using the Merge Type command.