Input to lookup stage

ashwin2912 · Post by **ashwin2912** » Thu May 26, 2005 5:42 am

Just wanted to know....what can be input (looked up) by a lookup stage. It can obviously be a file/table; but when I added a lookup to a file and then looked up to another (see below code) no records matched in Lkp2.

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

ray.wurlod · Post by **ray.wurlod** » Thu May 26, 2005 7:08 am

What you need to remember (or remind yourself by inspecting the generated OSH in Job Properties) is that, everywhere you have a link, there is a virtual Data Set.
So, in theory, you should be able to look up against anything.
However, note that the "sparse lookup" strategy for DB2, Oracle work a little differently.