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

    lony
      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
      T00000000000000000000

      Thanks,
      Lony
        1 2 3 Previous Next