5 Replies Latest reply: Dec 28, 2012 2:00 AM by lony RSS

    Write the output of a query in ODI to file

    lony
      Hi Friends,

      I am using ODI 11g.

      In ODI I want to write the output of the below query to a unix file.

      SELECT 'H'|| rpad('SB9KT.KTPRTO.EBSDATA.D0000000','30',' ')|| rpad(to_char(sysdate, 'YYYYMMDDHHMMSS'), 16, ' ')
      FROM dual;


      Please suggest any inputs.

      Thanks,
      Lony