Data Transformation Engine Map Designer Reference Guide

Chapter 8 - Functional Map Basics Functional Maps
Map Designer Reference Guide
139
The objective is to map this data to a file containing delimited records. The
delimited record has only the car name and the weight. In the delimited record,
the weight is in decimal format. The desired output data result is:
Marlin,29.30
Pacer ZSX,33.50
Wildcat,26.40
Fantasia DX,28.30
La Vella,20.70
Blue Baron,26.50
Cavalino,32.50
You want to generate one delimited record for each fixed record in the input file.
Input data Output data
Marlin 22 2 27 11 2930 Marlin,29.30
Pacer ZSX 17 3 26 11 3350 Pacer ZSX,33.50
Wildcat 22 3 18 12 2640 Wildcat,26.40
Fantasia DX 17 3 27 15 2830 Fantasia DX,28.30
La Vella 23 2 28 11 2070 La Vella,20.70
Blue Baron 25 2 26 12 2650 Blue Baron,26.50
Cavalino 20 4 29 16 3250 Cavalino,32.50
A map that maps the entire input file to the output file may look like this:
Define the map rule for the output CarRecord(s), with a range of
(s). There is
an indefinite number of CarRecord(s).