This discussion is archived
5 Replies Latest reply: Dec 28, 2012 12:00 AM by lony RSS

Write the output of a query in ODI to file

lony Newbie
Currently Being Moderated
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.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points