This document was uploaded by user and they confirmed that they have the permission to share
it. If you are author or own the copyright of this book, please report to us by using this DMCA
report form. Report DMCA
1. Initialize script - Like setting data format, Setting the path for Source files Choosing the jobs to execute or not by specifying Y/N
1
2. Conditional flow - to execute job/segment Y/N
Data Flows: First to map source fields to target fields (write to Template table) Data Flow to Validate - The source fields are validated here, doing Lookups for data validation, checking the source data for mandatory fields and validating the Format of the data; Writing all the passed records to one Template table and failed records to another Template table for further investigation.
2
3. Another script here to delete the invalid records (Delete the records from the