schema file layout

nani0907 · Post by **nani0907** » Mon Aug 27, 2012 5:26 am

Hi all,

I have a comma delimited file for which i had defined the schema file .But for one of the column i am getting comma in the value for one of the file.How should i define this property in schema file.

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

Thanks in advance .

ArndW · Post by **ArndW** » Mon Aug 27, 2012 6:05 am

I am afraid that I don't quite follow the first question, but unfortunately the schema does not contain information on whether or not the first line contains the column names, therefore there is no way to set this in a schema file.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 27, 2012 6:40 am

The parallel Sequential File stage is intolerant of field delimiters occurring within fields, even if they're quoted.

Best workaround is to use a server Sequential File stage within a server Shared Container in your parallel job.