Data Transformation Engine Design Studio Tutorial

Chapter 7 - Using Cross-Referenced Data Using the Map Designer to Generate Region Reports
Design Studio Tutorial
159
Each sales record contains the contact person, the company name, and the
region.
♦ The Contact Field, Company Field, and Region Field item types represent
these fields in each sales record.
! Analyze and save the type tree.
Using the Map Designer to Generate Region Reports
Create the Customer.mms map source file to contain the following maps:
♦ The CreateRegionFile executable map to generate a file that contains the zip
code and region of the customer.
♦ The RegionReport executable map to generate the regionreport.txt file that
contains customer records where each record contains the customer contact
and the region.
! The F_MakeSalesRecord functional map to use the two data sources (the
customer contact and the lookup record data) to create the sales record
where the zip code in the region lookup file is equal to the zip code in the
contact file.