Schema File: First Line is Column Names:FALSE/TRUE

etldeveloper2050 · Post by **etldeveloper2050** » Tue Sep 16, 2008 7:45 pm

Hi,
I have a job wherein i am reading data from a csv file using sequential file stage and passing the column definitions through a schema file. Its a common job which will be used for multiple files. Now some of the files comes with column name and some not, that's why i have kept First Line is Column Names option in sequential file stage as FALSE.

I wanted to know if we can mention "First Line is Column Names=FALSE/TRUE" in the schema file itself.

I hope my problem description is clear. If not please excuse me.
Thanks for your help.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 8:15 pm

Probably not, since this is a stage property not a link property. The schema is a link property.

nani0907 · Post by **nani0907** » Thu Aug 23, 2012 6:33 am

Hi ,

could any body confirm please whether we can use first name column property in schema file definition....

Thanks in advance