sequential file read running if the wrong delimeter
Posted: Thu Apr 07, 2011 6:37 am
Source is the comma delimited file.
Sample data:
"Emp name","Empno","sal"
"xxx","101","2000"
"bbb","102","4000"
"aaa","103","3000
I have given the below properties in the sequential file stage.
Record level
final delimter=end
Record delimiter=UNIX newline
Field defaults
Dlimeter=Comma
Quote=double
I am able to run the job. It is working. Some reason they have provided wrong delimiter in the file.
Sample data:
"Emp name" "Empno" "sal"
"xxx" "101" "2000"
"bbb" "102" "4000"
"aaa" "103" "3000"
even though i am having different delimeter in the source file. Still my job running fine.
But I want to fail my job if the file having wrong delimiter other than comma delimiter. It is not failing and running fine.
Any help greatly appreciated.
Thanks
Sample data:
"Emp name","Empno","sal"
"xxx","101","2000"
"bbb","102","4000"
"aaa","103","3000
I have given the below properties in the sequential file stage.
Record level
final delimter=end
Record delimiter=UNIX newline
Field defaults
Dlimeter=Comma
Quote=double
I am able to run the job. It is working. Some reason they have provided wrong delimiter in the file.
Sample data:
"Emp name" "Empno" "sal"
"xxx" "101" "2000"
"bbb" "102" "4000"
"aaa" "103" "3000"
even though i am having different delimeter in the source file. Still my job running fine.
But I want to fail my job if the file having wrong delimiter other than comma delimiter. It is not failing and running fine.
Any help greatly appreciated.
Thanks