Data Transformation Engine Design Studio Tutorial

Chapter 4 - Using the UNIQUE Function Summary
Design Studio Tutorial
115
Summary
The Mail.mms map source file now contains three executable maps and one
functional map.
Map Name Type of map Target = File Output Generated
ContactToLabel Executable Contact.txt A single mailing label.
ContactToFullLabel Executable FullContact.txt A file containing
multiple mailing
labels.
F_MakeLabels Functional n/a A mailing label record
for each contact
record.
UniqueContacts Executable Unique.txt A file containing only
the unique contact
records (duplicate
records were not
generated).
The UniqueContacts map was created when the ContactFile input card was
copied from the ContactToFullLabel map.
When created, the UniqueContacts map contained only the ContactFile input
card that was copied from the ContactToFullLabel map.
The ContactFile input card was copied to the output card. Copying the input card
to an output card enabled the input data to be mapped. The
UNIQUE function was
added to the map rule for the Contact data object. The output of the map was the
unique.txt file, which contained only the unique records (no duplicate records).