0

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!

PiPio
  • 89
  • 1
  • 3
  • 11

1 Answers1

2

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

Kevin Lee
  • 401
  • 3
  • 9
  • 22
  • Thankyou it works.. Really glad that someone comes to help :D – PiPio Nov 05 '19 at 04:11
  • Hey Lee Kevin can you also please help me with this? https://stackoverflow.com/questions/58705214/how-to-add-new-line-after-closing-tg-in-datastage-xml-output I'm trying out many different things at the moment – PiPio Nov 05 '19 at 06:07