Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Export table to flat file and need to insert sysdate in flat file column

1031799Aug 8 2013 — edited Aug 13 2013

Hi, I created an interface to export oracle table to a csv file. All of the table columns are working well. Then I need to insert the sysdate in csv file column.

I made the mapping as working in staging area, implementation is to_char(sysdate,'dd/mm/yyyy'). But the result is insert 14 to the column.

I have tried to create a variable refreshing as select to_char(sysdate,'dd/mm/yyyy') from dual, then mapping that to the column in csv file, but it only insert to 1 row and the format is yyyymmdd.

I have tried to use SELECT '<%=odiRef.getSysDate( "yyyyMMdd")%>' from dual for the variable, and it also only insert one row to the flat file.

I used the same methodology in ODI10g, it works fine.

So, I am wondering how it can be implemented in 11g.

Thanks

This post has been answered by 1031799 on Aug 13 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2013

Added on Aug 8 2013

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

4 comments

526 views