Page 1 of 1

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

Posted: Tue Sep 16, 2008 7:45 pm
by etldeveloper2050
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.

Posted: Tue Sep 16, 2008 8:15 pm
by ray.wurlod
Probably not, since this is a stage property not a link property. The schema is a link property.

Posted: Thu Aug 23, 2012 6:33 am
by nani0907
Hi ,

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

Thanks in advance