Data Transformation Engine Design Studio Tutorial

Chapter 2 - Modifying the Contact Type Tree Scenario

Design Studio Tutorial

Scenario

You have a Contact text file consisting of multiple records that contain

information about a customer.

Using the file of multiple records as input, you need to generate one mailing label

for each contact record in the input data. The input data contains optional data

objects; the records of some customers contain middle names or initials.

You need to modify the type tree that represents the input data to contain a

middle name field.

FullContact Record

The FullContact.txt file is a file of an unknown number of records that contain

information about customers. The records include the name of the contact person

at the company, the company name, the address, and the phone number. The

middle name is optional.

Use any text editor to view the FullContact.txt text input data file.

This input data can be described as a file consisting of multiple contact records

with each contact record consisting of many data fields.

dams,James,P,ABC Co.,29 Frankford Rd,Bloomington,IL,60525,708,3525555

First

Name

Street

State

City

Zip code

Phone

Area

code

FullContact

Last

Name

Company

Middle

Name

A portion of the input data is shown below:

Adams,James,P,ABC Co.,29 Frankford Rd,Bloomington,IL,60525,708,3525555

Miller,Maria,B,Conrad Corp,1234 Smith St,Buffalo Grove,CA,60089,708,3334567

Smith,Fred,A,Sand Inc.,Beach Street,Pismo Beach,FL,33321,407,8123456

Veldin,Beth,M,Any Co.,697 Berry Road,Highland Park,IL,60012,708,4445987

The type definitions of the Contact input record file, without consideration of the

middle name or initial, are defined in the Contact.mtt type tree. You will modify

the Contact.mtt type tree to include the type definition of the middle name field.