Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
276
Chapter 18 - Mapping Invalid Data
Invalid data can be rejected from the input data file by using the REJECT function.
This rejected data can be then mapped to an error file to provide useful
information that identifies errors in the input data.
Objectives
This chapter maps invalid data using the REJECT function.
By completing the exercises for Chapter 18, you will view a working map that:
♦ Maps invalid data.
♦ Uses the restart attribute.
♦ Uses the REJECT function to create an error output file.
Files Used in this Chapter
You will be working in the c:\mercator\tutorial\MyFolder\Ch18 folder. Use
the files provided in Ch18.zip.
Files Provided for Chapter 18
The following table describes the files provided for this chapter.
Icon File type Name Description
Text file Names.txt Input data file containing
customer information.
Type tree MyCustomers.mtt Type tree describing the input
customer data.
Type tree Errors.mtt Type tree describing the output
error data.