Multiple values returned from the lookup

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
datskosaraju
Premium Member
Premium Member
Posts: 48
Joined: Tue Nov 25, 2008 11:10 pm
Location: Des Moines,IA

Multiple values returned from the lookup

Post by datskosaraju »

Hi guys,

I am doing a lookup agianst a database Table and the stream input is a sequential file. Is there any way to check whether multiple records are returned from the reference table as a result of the lookup?
"It's easier to go down a hill than up it but the view is much better at the top"
-Bennet,Arnold
Top
dunquach
Participant
Posts: 4
Joined: Mon Jun 06, 2005 9:27 am

Re: Multiple values returned from the lookup

Post by dunquach »

datskosaraju wrote:Hi guys,

I am doing a lookup agianst a database Table and the stream input is a sequential file. Is there any way to check whether multiple records are returned from the reference table as a result of the lookup?
In Director, you will see the warning that tell you multiple records returning.
Top
datskosaraju
Premium Member
Premium Member
Posts: 48
Joined: Tue Nov 25, 2008 11:10 pm
Location: Des Moines,IA

Post by datskosaraju »

Thanks for the response.! But, I want check the condition in the datastage and use that as a constraint in my job
"It's easier to go down a hill than up it but the view is much better at the top"
-Bennet,Arnold
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Something wrong with the other post where you asked this exact same question? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”