Data Transformation Engine Design Studio Tutorial

Chapter 11 - Partitioning Types to Simplify Map Rules Scenario
Design Studio Tutorial
208
Icon File type Name Description
Map
source
options file
*.mopt Map options file created
automatically during the Save
process.
Backup
type tree
and map
files
*.bak Backup type tree files and
map source files are created
automatically during the Save
process.
Copies of the files created during the exercises are provided for all chapters in the
Tutorials\Solutions folder. The structure and use of these files is described in
the Design Studio Tutorial Solutions section on page 18.
Scenario
A file contains a collection of records in no particular order. The source of each
record may be one of three kinds of business partners: customers, suppliers, or
distributors. In addition, each record originates in one of three different
applications: a forecast, purchase order, or invoice application.
A particular field in each record indicates the business partner it came from and
another field indicates the associated application.
You want to create three different output files:
♦ A file of invoices to send to an accounting department.
♦ A file of purchase orders and forecasts to send to an order entry department.
♦ A report on the activity of customers, suppliers, and distributors for the MIS
department.
Using the Type Designer, you need to modify the type tree to:
♦ Define the data file of records.
♦ Partition the different kinds of records and define the activity report.
Using the Map Designer, you need to to create one map source file with:
♦ An executable map with two output cards:
! Output card #1 to generate a file for the accounting department
! Output card #2 to generate a file for the order entry department file.
♦ A second executable map to generate the activity report.