ODI - IKM SQL to File Append - Header not Generated
I'm using ODI IKM SQL to File Append to create a text file, but the header is not being generated. And the GENERATE_HEADER is set to Yes. The file is Tab delimited and the Heading (number of lines) is set to 1.
Seems to only be an issue with HFM files coming from the Unix server.
Any suggestions?
Thanks, Mike