Data Transformation Engine Design Studio Tutorial

Chapter 9 - Data Breaks by Object Count Scenario – Counting Objects
Design Studio Tutorial
183
Scenario – Counting Objects
A break in the data pattern can be recognized when the count of a certain object
reaches a specific value. You have a set of four contact records that need to be
mapped to a single record.
As shown in the illustration, the AddressFile data source contains multiple
ContactSets. Each ContactSet contains four Contacts.
The CompanyFile data target contains multiple Records. Within each Record,
there are four Company fields. You want to map the Company field of one
Contact in the ContactSet to one of the Company fields in Record.
Define a specific number of data objects as a single data object. Use the Type
Designer to define the address file in terms of ContactSets, and use a component
rule on the Contact component of ContactSet. Define the company file of
records.
Use the Map Designer to create a map that maps the AddressFile to the
CompanyFile. Create a functional map to map a single ContactSet to a single
Record.
Defining a specific number of data objects as a single data object enables each set
of four contacts to be recognized as a single data object. This allows you to map
each set of four contacts to a single record in the output.