It is obvious that by the time Lkp2 tried the lookup no records were ready from Lkp1.
Q1> Does Lookup stage output only after all recs are processed?
Q2> From what stages can a lookup stage lookup? (In one case I have an aggregator o/p being looked up and it works)
Code: Select all
file1->Lkp2
^
|
|
RefFile2->Lkp1
^
|
|
RefFile1