Data Transformation Engine Design Studio Tutorial

Contents
Design Studio Tutorial
7
Files Provided for Chapter 10 .......................................................................197
Files You Create or Modify for Chapter 10 ........................................................197
Scenario - Data Value Changes.......................................................................... 198
Control.mtt Type Tree.................................................................................... 199
Adding a Component Rule for Distinguishability .................................................200
Using Shorthand Notation in a Component Rule .................................................202
Data Handling ..........................................................................................202
Creating the MakeCountFile Map ....................................................................... 203
Summary .................................................................................................... 204
Chapter 11 - Partitioning Types to Simplify Map Rules
Objectives................................................................................................... 205
Files Used in this Chapter................................................................................ 206
Files Provided for Chapter 11 .......................................................................206
Files You Create or Modify for Chapter 11 ........................................................207
Scenario ..................................................................................................... 208
Partitioned Type Names..............................................................................209
Deliver.mtt Type tree .................................................................................... 210
Assigning the Identifier Attribute...................................................................211
Entering Component Rules...........................................................................212
Viewing Component Numbers ........................................................................... 215
Deliver Map Source File................................................................................... 218
OrdersByDept Executable Map ......................................................................218
ActivityReport Executable Map .....................................................................222
Summary .................................................................................................... 225
Chapter 12 - Mapping Optional Inputs
Objectives................................................................................................... 226
Files Used in this Chapter................................................................................ 226
Files Provided for Chapter 12 .......................................................................226
Files You Create or Modify for Chapter 12 ........................................................227
Scenario ..................................................................................................... 228
Input Data................................................................................................... 228
States.mtt Type Tree ..................................................................................... 229
Component Ranges ........................................................................................ 229
Using the Map Designer................................................................................... 234
Summary .................................................................................................... 236
Chapter 13 - Mapping Multiple Files to One File
Objectives................................................................................................... 237
Files Used in this Chapter................................................................................ 237
Files Provided for Chapter 13 .......................................................................237
Files You Create or Modify for Chapter 13 ........................................................238
Scenario ..................................................................................................... 238
Using Ellipses ............................................................................................... 239
TwoFiles.mtt Type Tree.................................................................................. 241
Input Detail Records ..................................................................................241
Input Header Records.................................................................................242
Output PO...............................................................................................243
Using the Map Designer................................................................................... 244
CreatePO Input.........................................................................................244
Generating the CreatePO Output...................................................................245