CODEWITHSUNDEEP
etldatastageibm-infosphere
PiPio
PiPio

Reputation: 99

How to include column name from oracle source to flat file (destination) in datastage?

I'm a total beginner and working my way to become a good ETL developer and i uses IBM Infosphere Datastage. I'm able to transfer/import data from databases(Oracle) to sequential file(csv) but i wanted to get the columns name? is there a way to do it ? i don't have anyone that taught me, i just do it by myself So any idea would be very helpful. Thanks!

Upvotes: 0

Views: 950

Answers (1)

Kevin Lee
Kevin Lee

Reputation: 469

In the sequential file stage, simply set the option "First Line is Column Names = True", compile and run the job then you will see the column names in the csv file. enter image description here

Upvotes: 2

Related Questions