How to reject invalid records from a sequential file
Posted: Fri Oct 14, 2005 11:55 am
Hi,
I have a staging job which reads from a source sequential file (pipe delimeted) and then loads valid records into a staging table. The problem with the source file is, 2 or 3 records have incomplete number of columns. I want these rows to go to a reject file and only load those valid records in the staging table. Is there a way to filter these bad records? I guess I can use a constraint in the transformer, but what would the constraint be?
Appreciate your help in advance.
I have a staging job which reads from a source sequential file (pipe delimeted) and then loads valid records into a staging table. The problem with the source file is, 2 or 3 records have incomplete number of columns. I want these rows to go to a reject file and only load those valid records in the staging table. Is there a way to filter these bad records? I guess I can use a constraint in the transformer, but what would the constraint be?
Appreciate your help in advance.