Sequential File Rejects
Posted: Tue Sep 16, 2008 5:23 pm
Hi
The sequence of the stages in my job is as below
Seq_File_Source--->Transfomer--->Lookup--->Seq_File_Target
Not even a single record is getting inserted into my target sequential file.
Selective text from job log of director which might be helpful
1)FIN_HDR,0: Import complete; 516 records imported successfully, 0 rejected.
2)TR_LKP,0: Output 0 produced 516 records.
3)LKP_HDR,0: Input 0 consumed 435 records.
4)LKP_HDR,0: Output 0 produced 1 records.
Output 1 produced 0 records.
5)LKP_HDR,0: Output 0 produced 516 records.
6)HDR_TARGET,0: Input 0 consumed 516 records.
7)HDR_TARGET,0: Export complete; 0 records exported successfully, 516 rejected.
I dont get why all the records are rejected.
I tried having a reject link and write to a reject file.
But even then they are getting rejected at the reject file instance.
That makes sense because both cases are file targets and have the same metadata.
I do the exactly same lookup in several other jobs and they all run fine.
Is there any other location(other than director) where i can find detailed reasons why datastage/file is rejecting these records?
I used to use Informatica earlier the log gives in very detail about any rejects. Datastage just says rejected does not give any reason.
The sequence of the stages in my job is as below
Seq_File_Source--->Transfomer--->Lookup--->Seq_File_Target
Not even a single record is getting inserted into my target sequential file.
Selective text from job log of director which might be helpful
1)FIN_HDR,0: Import complete; 516 records imported successfully, 0 rejected.
2)TR_LKP,0: Output 0 produced 516 records.
3)LKP_HDR,0: Input 0 consumed 435 records.
4)LKP_HDR,0: Output 0 produced 1 records.
Output 1 produced 0 records.
5)LKP_HDR,0: Output 0 produced 516 records.
6)HDR_TARGET,0: Input 0 consumed 516 records.
7)HDR_TARGET,0: Export complete; 0 records exported successfully, 516 rejected.
I dont get why all the records are rejected.
I tried having a reject link and write to a reject file.
But even then they are getting rejected at the reject file instance.
That makes sense because both cases are file targets and have the same metadata.
I do the exactly same lookup in several other jobs and they all run fine.
Is there any other location(other than director) where i can find detailed reasons why datastage/file is rejecting these records?
I used to use Informatica earlier the log gives in very detail about any rejects. Datastage just says rejected does not give any reason.