Data Transformation Engine Design Studio Tutorial

Contents
Design Studio Tutorial
4
Scenario .......................................................................................................53
FullContact Record.....................................................................................53
Label Output ............................................................................................ 54
Starting the Type Designer.................................................................................54
Exploring the Contact Type Tree ....................................................................55
Type Properties..............................................................................................57
Viewing Type Properties....................................................................................57
Properties of the Contact Group Type...................................................................59
Components of Contact.....................................................................................60
Classification Hierarchy ....................................................................................60
Adding a New Type.....................................................................................61
Adding Components to Group Types .....................................................................64
Component Ranges .....................................................................................66
Saving the Contact.mtt type tree ...................................................................68
Summary ......................................................................................................69
Chapter 3 - Modifying the Mail.mms Map Source File
Objectives.....................................................................................................70
Files Used in this Chapter..................................................................................71
Files Provided for Chapter 3..........................................................................71
Files You Create or Modify for Chapter 3...........................................................72
Scenario .......................................................................................................73
Copying an Input Card ......................................................................................73
Modifying the ContactToFullLabel Map..................................................................75
Creating the Label Output Card......................................................................76
Editing the ContactFile Input Card ..................................................................79
Creating the Map Rule for Label(s)..................................................................80
Executable and Functional Maps..........................................................................80
Functional Maps.........................................................................................81
General Functional Map Guidelines .................................................................82
Functional Map Wizard ................................................................................85
Entering Map Rules..........................................................................................88
Mapping to the Company Field.......................................................................89
Data Object Name Reminder .........................................................................91
Viewing Map Rules...................................................................................... 91
Sizing the Rule Column and Output Column .......................................................91
Mapping to the Street Field...........................................................................92
Mapping to CityStateZip Field........................................................................92
Mapping to the FullName Field.......................................................................94
Mapping the FullName Field.......................................................................... 95
Saving the Mail.mms Map Source File.................................................................. 100
Building the ContactToFullLabel Map.................................................................. 100
Running the ContactToFullLabel Map.................................................................. 101
Results...................................................................................................101
Viewing the ContactToFullLabel Map Run Results ...............................................101
Summary .................................................................................................... 104
Chapter 4 - Using the UNIQUE Function
Objectives................................................................................................... 105
Files Used in this Chapter................................................................................ 106
Files Provided for Chapter 4.........................................................................106
Files You Create or Modify for Chapter 4..........................................................107