1 2 3 Previous Next 35 Replies Latest reply: Dec 21, 2012 7:34 AM by huny RSS

    How to Add Header and Footer in Flat file

      HI All,

      I am using ODI 11g.

      MY interface is populating data from joining to 2 tables through sql query and Loads in to Flat file.
      But i need to add Header and Footer in the Flat file.

      In the below 3 lines
      The 1st line is header ....2nd line is Data ....3rd line is Footer.

      Any ideas how to work on this.

      HSB9KT.KTPRTO.EBSDATA.D0000000 20120626020636
      CFFE00263 SOLGSR014991340000527894536058173880207SOLNE06242012072420120000009048382650000247MRS

        1 2 3 Previous Next