datastage lookup stage
Posted: Tue Jan 05, 2010 3:47 am
Hi,
Job details: I have input file which is having 50,000 records and joining with 3 files(file1,file2,file3)based on single key.
The output file contain 45,000 records and the reject link contains the 5,000 records.
As per the process, I should get the 50,000 records but 5,000 records are rejected. Now I want to find out which file (file1,file2,file3) data is not matching with the source.
File1 file2 file3
V V V
input_file --------> lookup_stage ------------> output/file
V
Rejects
Now I am following this approach which is having less number of rejected records(<=10).
Head on the rejected file taking each key column value and searching in the file1,2,3. I can easily find in this process.
When I have large amount of rejects, it is very difficult for me to identify which file having the rejects.
Please suggest me which is the best way to find on this senario.
Job details: I have input file which is having 50,000 records and joining with 3 files(file1,file2,file3)based on single key.
The output file contain 45,000 records and the reject link contains the 5,000 records.
As per the process, I should get the 50,000 records but 5,000 records are rejected. Now I want to find out which file (file1,file2,file3) data is not matching with the source.
File1 file2 file3
V V V
input_file --------> lookup_stage ------------> output/file
V
Rejects
Now I am following this approach which is having less number of rejected records(<=10).
Head on the rejected file taking each key column value and searching in the file1,2,3. I can easily find in this process.
When I have large amount of rejects, it is very difficult for me to identify which file having the rejects.
Please suggest me which is the best way to find on this senario.