Hi,
My requirement is to check the value for a particular field.If the value is null then send the entire record to error table else pass it to output.
I am using the following condition in the constraint field.
IsNull(input column)
the job executes well but the error table is not populated with the null records.null records pass through the target.
Please help and thanks in advance.
regards
Removing a record with null field using transformer
Moderators: chulett, rschirm, roy