As we know lookup stage can handle multiple reference files in one stage.
I need to confirm the following,
- Same table with different source columns and with the same reference columns matching, Can I use one lookup stage to populate different output fileds using the one key field from the reference?
Lookup Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 80
- Joined: Sat Mar 18, 2006 10:27 pm
That means, I have to use copy stage to expose that one reference file into mutiple files and then able to pull the required fields to the output. Right?
Also, How does it work with AND condition and OR condition? Like, we have in server,
If I have mutiple reference links on one lookupstage, I have to determine what's found and what's not found..and then use logical operators to determine which one should go to output.
Also, How does it work with AND condition and OR condition? Like, we have in server,
If I have mutiple reference links on one lookupstage, I have to determine what's found and what's not found..and then use logical operators to determine which one should go to output.
Yes...copy stage or transformer.
You can:
a) Perform all of the lookups in one stage (or separate stages) then use a transformer afterwards to choose between the three results.
b) Perform each lookup individually, passing rejects to the next lookup and funnel the results back together at the end
There is no OR construct in a parallel lookup stage.
Regards,
You can:
a) Perform all of the lookups in one stage (or separate stages) then use a transformer afterwards to choose between the three results.
b) Perform each lookup individually, passing rejects to the next lookup and funnel the results back together at the end
There is no OR construct in a parallel lookup stage.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.