ODI 12C Table to Flat File Mapping

Any idea on how do we get the column names as header in the csv file that is generated?

How to get the column names in the CSV file which we have unaloded??

Hi Praveen, is it possible to convert or map a Json file into CSV?? could you please post a video on that???

Hi Praveen, how are you doing? I will like to use this medium to say thank you for the all the great video's that you've been posting on your channel. With that been said, Praveen, I have requirement to dump some data(s) from on-premises to Oracle Object Storage using "ODI 12c." I have tried using ftmcli by first loading into a flat file.

Things I have tried
1) Created a mapping from Table to Flat file
2) Ran the mapping using a custom IKM that I got from a friend
3) Was able to load to the flat file but the KM "did not send it to the object storage."

So, I was wondering if you have any custom KM that can help me in achieving this task by supplying my cloud authentication parameters.

And, I'm using ftmcli latest version 2.4.


Thanks, any help will be greatly appreciated.

Hi Praveen, why the file is not created in the location I specified

Hi Praveen, Thank you for the video. How to load the data with heading(column names) information.

Hi,
Thank you for the video, it was useful to learn the "sqlunload utility".
But I have an issue, how to load the data with headers and why is that I am not able to use "IKM SQL to FIle Append" in my mapping. Can you please help me with this.
Thank you.