Hello,
I have a scenario, wherein I have a
Dataset==>Transformer==>Lookup==>Dataset
There's one set of records [Input Field1=00]in Input wherein it wouldn't find a Lookup in the Reference, and it should just pass the entire Input record to the Output. For the rest of the records [Input Field1 <> 00], Do a lookup and derive some values..
How do I selectively put a Constraint for this case.
Thanks
Vijay
Lookup - Selective Records; Other Continue
Moderators: chulett, rschirm, roy
You can have a reject link coming out of the Lookup Stage that will carry records which will fail the lookup. Send both the inputs (lookup successful and lookup failure which is the reject link) to a funnel stage. The output of funnel stage can go to your final dataset.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Thanks for the suggestion. I had that in mind, but I want to see if there's a way w/o using any additional stage to accomplish thisDSguru2B wrote:You can have a reject link coming out of the Lookup Stage that will carry records which will fail the lookup. Send both the inputs (lookup successful and lookup failure which is the reject link) to a funnel stage. The output of funnel stage can go to your final dataset.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
If you have the right version of DataStage, I think it's the latest Unix/Linux version but not the Windows version, you can do a conditional lookup using the parallel lookup stage. The constraints form lets you enter a condition on whether the lookup should be performed for each row using values in the input link.
This lets you skip the lookup for rows that meet the criteria.
This lets you skip the lookup for rows that meet the criteria.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: