Data Transformation Engine Design Studio Tutorial

Contents
Design Studio Tutorial
6
Scenario ..................................................................................................... 154
Modifying the Customer.mtt Type Tree ............................................................... 154
Region Data.............................................................................................155
Record Group Type Represents Region Records..................................................155
RegionRecordsFile Group Type Represents the File.............................................157
Save the Customer.mtt Type Tree .................................................................158
Output Types ............................................................................................... 158
Using the Map Designer to Generate Region Reports................................................ 159
Creating the CreateRegionFile Map ................................................................160
Creating the RegionReport Map......................................................................... 162
Creating the F_MakeSalesRecord Functional Map.................................................... 162
Using the LOOKUP Function..........................................................................162
Using the Functional Map Wizard ...................................................................163
Modify the F_MakeSalesRecord Functional Map..................................................164
Generating the Output of SalesRecord ................................................................ 165
Using the SORTDOWN Function.......................................................................... 166
Creating the SortRegion_Descending Map............................................................. 166
Optional Exercise.......................................................................................... 168
Using the SEARCHUP Function........................................................................... 168
Creating the RegionReport_SEARCHUP Map........................................................... 169
Optional Exercise......................................................................................170
Chapter 8 - Using the CHOOSE Function
Objectives................................................................................................... 171
Files Used in this Chapter................................................................................ 171
Files Provided for Chapter 8.........................................................................171
Files You Create or Modify for Chapter 8..........................................................172
Scenario ..................................................................................................... 173
Generating the Congratulations Message File ........................................................ 173
Raffle.mtt Type Tree ..................................................................................... 174
PrizeRecord Group Type..............................................................................175
PrizeFile Group Type..................................................................................175
WinnerFile Group Type ...............................................................................176
CongratulationsRecord Group Type ................................................................176
CongratulationsFile Group Type ....................................................................177
Raffle Map .................................................................................................. 178
Summary .................................................................................................... 179
Chapter 9 - Data Breaks by Object Count
Objectives................................................................................................... 180
Files Used in this Chapter................................................................................ 181
Files Provided for Chapter 9.........................................................................181
Files You Create or Modify for Chapter 9..........................................................181
Scenario – Counting Objects ............................................................................. 183
Merging the Contact Group Type ....................................................................... 184
Adding a Component Rule............................................................................187
Using the Map Designer................................................................................... 192
Summary .................................................................................................... 195
Chapter 10 - Data Break by Value
Objectives................................................................................................... 196
Files Used in this Chapter................................................................................ 197