Skip to Main Content
Forums

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!

odiFileAppend not working

2655429Oct 5 2017 — edited Oct 12 2017

Hi Experts!

I have the flow export the execution stats from a repository table using odiSQLUnload and then append header to the file using odiFileAppend.

The file format for both the files is .xls. odiSQLUnload exports the contents of the table to the file. I have created a file named Header.xls which contains pre-written header columns.

In odiFileAppend I give the header file and name of the file which is created by odiSQLUnload. But somehow the append is not happening.

The header file is contains only headers and no data after the execution of package completes.

To add if I enable flag 'Overwrite File' in odiFileAppend, it surprisingly copies the content of other file.

Below is the snapshot of the flow -

pastedImage_0.png

Any pointers will be of help!

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2017
Added on Oct 5 2017
#business-intelligence-applications, #data-integrator, #system-management-and-integration
17 comments
769 views