Doubt in Lookup

[somu_june]

Hi,

Can any one help me .I have a requirement like this, I want to Lookup a DB2 table . I have to join the keys from_src (flat file ) and Lookup table. And I want to write the output to three stages

1. To the seq file with constraint : Is Null (Lkup_Tab.BB)
2. To the seq file with constraint : Not Is Null (Lkup_Tab.BB)
3. To the Aggregator stage with no constraint.


Which Stage I have to use to achieve this. I Read lookup stage can have only one output and one reject link. Can I use Lookup file set stage so that I can write DB2 table data in lookup file set stage and do look up by joining the keys of source file with lookup fileset stage keys in transformer stage and output to three outputs that I have mentioned above . Please correct me if Iam wrong and also guide me how to achieve my target

Thanks,
Somaraju.

[reachthiru]

Hi,

Instead of using Lookup stage, what you can do is, do the outer join of your main table with the lookup table and pass it to a TRANSFORMER stage. There you can have 3 outputs and you can add your constraints there.