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
samba
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 07, 2005 11:44 am

Lookup

Post by samba »

Here i am using Lookup stage, if the condition is not met i need to capture the records in target, where condition is not met need to load into reject file

Is it possible ??
samba
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Both the above mentioned conditions are the same !
Thanks,
Vinay
samba
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 07, 2005 11:44 am

Post by samba »

yes
samba
samba
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 07, 2005 11:44 am

Post by samba »

I need to capture where condition is not met and also
if the condition is not met also i need to load the data into target
samba
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Hi,

In the Lookup stage, use 'Reject ' option(for condition not met) and write the reject link to a copy stage.

From the copy stage you can capture the results and also write to a target (2 Streams) .
Thanks,
Vinay
Post Reply