Generic lookup with Datastage 7.5

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gbusson
Participant
Posts: 98
Joined: Fri Oct 07, 2005 2:50 am
Location: France
Contact:

Generic lookup with Datastage 7.5

Post by gbusson »

Hi everybody,

My team is developping generic jobs with RCP. A fist version is 7.0. Migration to 7.5 is coming soon. We have a problem with lookups in 7.5. Since there is a graphical tool to define the keys, parameters are not allowed, unlike in 7.0.

Do you have a solution, or do i have to define the key column in the flow?
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

Would it work with the join stage? You might also be able to replace your lookup stages with a custom operator stage that calls the lookup function without the GUI. Not sure how this would go with job parameters and RCP though.
Post Reply