I cannot find the lookup stage in my pallette. This stage is mentioned in the parallel jobs documentation, and now I cannot find a parellel job option in my datastage client. What's going on here.. is it like the edition I have is not the enterprise edition? or is there something like a menu option that I need toggle on or off?
Thanks!
Cannot find lookup stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Cannot find lookup stage
One person for immediate DataStage training
In the server edition it's e.g. just a regular database stage. The first one you connect to a transformer will get a full line, the rest you connect are lookups by default (which broken lines) and use slightly different semantics.
The primary stage will supply the main "row" and fields of that row can then be used to in the lookup stage to get additional data fields based on the primary key in a different table... it's all pretty neatly described in the documentation.
Ogmios
In the server edition it's e.g. just a regular database stage. The first one you connect to a transformer will get a full line, the rest you connect are lookups by default (which broken lines) and use slightly different semantics.
The primary stage will supply the main "row" and fields of that row can then be used to in the lookup stage to get additional data fields based on the primary key in a different table... it's all pretty neatly described in the documentation.
Ogmios
In theory there's no difference between theory and practice. In practice there is.
If in the Designer you don't have an option to create Parallel jobs, you don't have the Enterprise Edition.
And you're not the first person to be thrown by the online help, which includes every stage for all products. You'll find a Conditional Lookup in there as well, too bad it's only for the 390 product.
And you're not the first person to be thrown by the online help, which includes every stage for all products. You'll find a Conditional Lookup in there as well, too bad it's only for the 390 product.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The parallel job's Lookup stage allows for conditional lookup, and supports a business rule for handling the situation that the condition is not met, separately from the situation that the lookup failed.
This is functionality that would be really useful in server jobs but, sadly, isn't there. Phil Walker's been asking for it for years!
This is functionality that would be really useful in server jobs but, sadly, isn't there. Phil Walker's been asking for it for years!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.