Scribd Logo
Upload

Welcome to Scribd!

  • 53 views

    Name of Solution: Business Requirement:: Please Rate This Solution and Share Your Feedback On Website

    Uploaded by

    Dudi Kumar
    This Informatica mapping separates header, footer, and data records from a flat file source and writes each to a separate target file. It uses router transformations to segregate the header and footer based on field values, and sends the remaining records to the details output. The steps are to import the mapping XML, copy the sample source file, observe how the routers separate header and footer, validate and run the mapping.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Name of Solution: Business Requirement:: Please Rate This Solution and Share Your Feedback On Website

    Uploaded by

    Dudi Kumar
    53 views3 pages
    This Informatica mapping separates header, footer, and data records from a flat file source and writes each to a separate target file. It uses router transformations to segregate the header and footer based on field values, and sends the remaining records to the details output. The steps are to import the mapping XML, copy the sample source file, observe how the routers separate header and footer, validate and run the mapping.

    Original Description:

    234

    Original Title

    Userguide_2357

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This Informatica mapping separates header, footer, and data records from a flat file source and writes each to a separate target file. It uses router transformations to segregate the header and footer based on field values, and sends the remaining records to the details output. The steps are to import the mapping XML, copy the sample source file, observe how the routers separate header and footer, validate and run the mapping.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    53 views3 pages

    Name of Solution: Business Requirement:: Please Rate This Solution and Share Your Feedback On Website

    Uploaded by

    Dudi Kumar
    This Informatica mapping separates header, footer, and data records from a flat file source and writes each to a separate target file. It uses router transformations to segregate the header and footer based on field values, and sends the remaining records to the details output. The steps are to import the mapping XML, copy the sample source file, observe how the routers separate header and footer, validate and run the mapping.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    Name of Solution:

    Informatica Developer : Separate Hdr Ftr Body

    Business Requirement:
    This Informatica Developer mapping demonstrates how to segregate header, footer and the rest of the data from a source flat file and write them to different target files.

    Solution URL:
    https://community.informatica.com/solutions/2357

    Supported Versions:
    Informatica Developer 9.5.1

    Description:
    Flat files are one of the popular formats of source data in any data integration or data warehousing projects. More than often, you receive flat files with more information than you actually need. For example, getting header, footer, summary information along with actual data. You may want to omit or separate extra information from the flat file source and process only source records. The mapping sample given here does the same. In the example given here, mapping separates header, footer and records and writes them to three separate target files.

    Download file contents:


    1. Mapping 2. Source File

    Please rate this solution and share your feedback on Marketplace Website.

    Steps to implement the solution:


    1. Import mapping xml to the repository, select the appropriate folder from repository and resolve the conflicts by choosing suitable option. 2. Copy the source file EmailSrc.csv into < Informatica server >\tomcat\bin\source 3. Open mapping in Informatica Develpoer, observe the router transformation which separates the header as shown below.

    4. The same logic is applied to separate footer. Router transformation accepts the descendingly sorted input so footer can read first. Remaining data has been passed as details output after sorting again.

    Please rate this solution and share your feedback on Marketplace Website.

    5. Validate and Run the Mapping.

    Please rate this solution and share your feedback on Marketplace Website.

    You might also like