Data Transformation Engine Design Studio Tutorial

Chapter 11 - Partitioning Types to Simplify Map Rules Deliver Map Source File
Design Studio Tutorial
222
ActivityReport Executable Map
The executable map ActivityReport uses the same input file and generates the
Report.txt file that contains an activity report with statistics about the records in
the input data.
♦ Create the ActivityReport map in the Deliver.mss map source file.
♦ Use the Deliver.mtt type tree.
The input data source is the same - the deliver.txt file.
Name the output card Report. The ActivityReport type represents the
Report.txt file.
Generating the Report.txt File
The ActivityReport type represents the Report.txt output file. Each component
of ActivityReport requires map rules.
♦ Use the
CURRENTDATE function for the Date Field item. When the
CURRENTDATE function is used for a date/time output item, the current date is
returned in the format specified by that output item.
Note Although the CURRENTDATE function has no arguments, it does require
parentheses.
On the output card, right-click the Date Field data object and choose Properties
from the context menu. View the Format property to confirm the MMDDYY format
of the generated date. Close the properties window.