multiple lookup condition

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
qutesanju
Participant
Posts: 373
Joined: Tue Aug 26, 2008 4:52 am

multiple lookup condition

Post by qutesanju »

Lokup condition
In one lookup itself can i put both condition?

(ToLkp.Flag ='INT' And ISNULL (ToLkp.Table_id))
(ToLkp.Flag ='EXT' And ISNULL (ToLkp.Table_id))
so i dont need to use two separate lookups for one for each condition
qutesanju
Participant
Posts: 373
Joined: Tue Aug 26, 2008 4:52 am

Post by qutesanju »

lookups are on same table and i need to get 4 columns from first lookup
and this will get passed to second lookup as input flow
right now i implemented two separate lokup ,but i m not sure why its not retriving the lookup filed(4 columns)
i mapped 4 columns into one flow should i leave them blannk while maping to next lookup?OR how to combine 4 columns from first lookup and 4 columns from 2nd lookup? i know that incoming record will have to pass thru either 1st lookup or 2nd lookup only,so querstion is how to combine/passthru 4 columns from first lookup and 4 columns from second lookup
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The results of one lookup cannot be used as values for another lookup within one lookup stage, you would need to use 2 stages in order to do that.
Post Reply