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
TLR 4

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
    Selenium
    ETL Testing
    AWS
    Python Online Classes

    ReplyDelete