I have a flat file with the following records
Code: Select all
"Empno","Ename","Salary","Deptno","JoiningDate"
1,"a",5000,100,2006-01-01
2,"b",,100,2006-01-01
3,"c",,,
Code: Select all
Empno number(4) not null
Ename varchar(50) not null
Salary decimal (12,5) not null
deptno number(4) not null
Joining Date Date not null
I have a reject link from the flat file to handle reject records.
I expected the records 2&3 to be rejected in the reject link. But this is not the case.
Do you have any pointers for this?
Regards
Nagesh