Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
126
Chapter 6 - Using the OR Function
with a Lookup File
You need to generate labels for only the preferred customers in the address file.
Objectives
This exercise introduces creating type trees and the concept of creating a lookup
file.
By completing the exercises for Chapter 6, you will learn how to:
♦ Create a type tree that represents preferred customers.
♦ Change type properties in the Properties window.
♦ Use type inheritance for creating subtypes.
♦ Define group types as Explicit or Implicit.
♦ Define terminators and delimiters.
♦ Index the output object to generate a specific number of occurrences.
♦ Use the
TODATETIME function to convert a text literal to a date format.
♦ Generate a lookup file of preferred customers as output of a map.
Files Used in this Chapter
You will be working in the c:\mercator\tutorial\MyFolder\Ch06 folder.
Files Provided for Chapter 6
The following table describes the files provided for this chapter. Use the files
provided in Ch06.zip.
Icon File type Name Description
Text file FullContact.txt Input data text file that
contains multiple contact
records of information about
customers.