Schema File
Posted: Tue Feb 28, 2012 9:57 am
Hi,
I have Common Job which extracts the data from multiple files with n number of fields. In Job, we use Column Import Stage with Schema File to import into multiple fields as we initially read file as single field.
When we do testing we send more no. of delimiters(|) than expected(Eg: we have two fields, but we send 5 delimiters. We expect it should reject the row but it has sent the rows to output with
Col1, Col2
Value1,|||||
Thanks
I have Common Job which extracts the data from multiple files with n number of fields. In Job, we use Column Import Stage with Schema File to import into multiple fields as we initially read file as single field.
When we do testing we send more no. of delimiters(|) than expected(Eg: we have two fields, but we send 5 delimiters. We expect it should reject the row but it has sent the rows to output with
Col1, Col2
Value1,|||||
Thanks