Data Transformation Engine Design Studio Tutorial

Contents
Design Studio Tutorial
5
Scenario ..................................................................................................... 108
Copying an Input Card to a New Map................................................................... 108
Copying an Input Card to an Output Card............................................................. 109
Editing a Card .............................................................................................. 111
Summary .................................................................................................... 115
Chapter 5 - Using the EXTRACT Function
Objectives................................................................................................... 116
Files Used in this Chapter................................................................................ 116
Files Provided for Chapter 5.........................................................................116
Files You Create or Modify for Chapter 5..........................................................117
Scenario ..................................................................................................... 118
Extracting Contacts for a Specific State............................................................... 118
Copying the ContactToFullLabel Map .................................................................. 118
Defining a New Input File ............................................................................120
Defining a New Output File ..........................................................................120
Entering a Map Rule to Extract Specific Records .................................................... 121
Card Naming Conventions............................................................................121
Summary .................................................................................................... 125
Chapter 6 - Using the OR Function with a Lookup File
Objectives................................................................................................... 126
Files Used in this Chapter................................................................................ 126
Files Provided for Chapter 6.........................................................................126
Files You Create or Modify for Chapter 6..........................................................127
Scenario ..................................................................................................... 128
Type Designer and Map Designer Tasks............................................................128
Using the Type Designer.................................................................................. 129
Using Type Inheritance ...............................................................................129
Creating the Preferred Type Tree ...................................................................... 130
Naming the Preferred Type Tree ...................................................................131
Creating the PreferredFile Group Type............................................................133
Creating the Field Item Types.......................................................................134
Defining the PurchaseDate Item Properties.......................................................135
Defining the Customer Group Type.................................................................136
Defining the PreferredFile Group Type............................................................140
Saving and Analyzing the Preferred Type Tree...................................................142
MakePreferredData Map.................................................................................. 142
Creating the PreferredFile Output Card...........................................................143
Creating Multiple Occurrences of Customer ......................................................143
Creating the Map Rules...............................................................................144
Using the TODATETIME Function....................................................................145
Generating Customer[2] and Customer[3] Output...............................................146
Building and Running the MakePreferredData Map ..............................................147
Extracting Contacts that are Preferred................................................................ 147
Summary .................................................................................................... 149
Chapter 7 - Using Cross-Referenced Data
Objectives................................................................................................... 150
Files Used in this Chapter................................................................................ 151
Files Provided for Chapter 7.........................................................................151
Files You Create or Modify for Chapter 7..........................................................152