Thursday, 9 May 2013

tFileInputMSDelimited - Processing Multi schema files using Talend

Source File:

HDR 2013-05-09

DTL Alex F. 42 10 2
DTL John K. 19 22 2
DTL Ross A. 32 31 2
DTL David L. 25 14 2

There are 3 different record types in the source file.different schemas for Header, Detail and Trailer records.

Job Design:

Multi Schema Editor -

Multi Schema Editor - Header Schema configuration

Multi Schema Editor - Detail Schema configuration
Multi Schema Editor - Trailer/Footer Schema configuration

Job Output

You may also like to read..

1 comment:

  1. Fantastic blog! Thanks for sharing a very interesting post, I appreciate to blogger for an amazing post.
    Data Science
    ETL Testing
    Python Online Classes