I have a scenario where i want to read data from DB table and put the column headers of the Table alone in the output file.
I have below components used.
tMSSQLInput(Dynamic data Type) --- tfileoutputdelimited
But When i process this, I'm getting headers and also data from the table, I dont want data from the table, I just want to read the columns present in the table and print in an Output file.
Thanks for your help.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables