Lookup failure
Posted: Mon Sep 25, 2006 6:58 pm
Hello:
Source File - Sequential file
Target Seq File
Requirement:
Input Seq File has column NAME, and ID
I want to look in column NAME for values "A" and "B"
and look in column ID for value
If NAME = "A" and ID = '1' AND
if NAME = "B" and ID = '1' then output record where NAME = 'B'
What I am doing:
I am using the filter stage where NAME = 'A'
Where Name = 'B'
sending NAME = 'A' in one output link to a lookup stage and NAME = 'B' in second output link the transformer.
Doing a lookup from the transformer to the lookup stage based on ID.
Sending the output to transform_2 and set a constraint in the transform_2 to output NAME = 'B' to the seq file.
When I run the job get the following errors:
QUESTION
Why is it giving that error...? Whats wrong?
What does this error mean?
Source File - Sequential file
Target Seq File
Code: Select all
Reject Seq file
|
\/
Seq file ---> Filter --> Lookup -----> Transformer_2 ----> Seq File
| /\
| /
\/ --/
Transformer_1
Input Seq File has column NAME, and ID
I want to look in column NAME for values "A" and "B"
and look in column ID for value
If NAME = "A" and ID = '1' AND
if NAME = "B" and ID = '1' then output record where NAME = 'B'
What I am doing:
I am using the filter stage where NAME = 'A'
Where Name = 'B'
sending NAME = 'A' in one output link to a lookup stage and NAME = 'B' in second output link the transformer.
Doing a lookup from the transformer to the lookup stage based on ID.
Sending the output to transform_2 and set a constraint in the transform_2 to output NAME = 'B' to the seq file.
When I run the job get the following errors:
Lookup_90: When checking operator: On output data set 0: Dropping component "NAME" because of a prior component with the same name.
Lookup_90: When checking operator: On output data set 0: Dropping component "ID" because of a prior component with the same name.
Lookup_90: When checking operator: On output data set 0: Dropping component "XYZ" because of a prior component with the same name.
DCSDIM_DCSCIM_DCSDIU,0: Progress: 10 percent.
DCSDIM_DCSCIM_DCSDIU,0: Progress: 90 percent.
DCSDIM_DCSCIM_DCSDIU,0: Import complete; 45558 records imported successfully, 0 rejected.
Reject,0: Export complete; 0 records exported successfully, 0 rejected.
C_AR_003_7_14_06_1_27_PM_5(Xfm_2).#0.Xfm_2: DSD.StageRun Active stage finishing.
0 rows read from Lkp_Out
0 rows written to tgt
0.010 CPU seconds used, 0.027 seconds elapsed.
Output,0: Export complete; 0 records exported successfully, 0 rejected.
main_program: Step execution finished with status = OK.
main_program: Startup time, 0:02; production run time, 0:00.
Parallel job reports successful completion
Finished Job C_AR_003_7_14_06_1_27_PM_5.
QUESTION
Why is it giving that error...? Whats wrong?
What does this error mean?
