Data Transformation Engine Design Studio Tutorial

Chapter 7 - Using Cross-Referenced Data Scenario
Design Studio Tutorial
154
Scenario
You have the unique.txt file of unique contacts. This data is not in any particular
sequence. The geographical region information is not contained in this input file.
You need to generate a cross-reference region.txt file that contains records
identifying the name of each customer contact, their company, and their
geographical region.
You need to generate the regionreport.txt file that contains the contact name,
company name, and the region.
Modifying the Customer.mtt Type Tree
Define the lookup file and the output file group types in the Customer.mtt type
tree. You can define both the lookup data and the output file types in the same
type tree. Modify the Customer.mtt type tree to define the group types and
components of the groups to represent the company, contact, region, and zip code
data.