Schema File: First Line is Column Names:FALSE/TRUE
Posted: 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.
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.