Datastage

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
Palci
Participant
Posts: 14
Joined: Thu Nov 17, 2011 10:56 am

Datastage

Post by Palci »

I ahve a parallel job in whic I am using Constarints on lookup. I am putting 2 conditions and they are like
1) src.a = ref.a ; If condition not met - drop; If lookup failure - drop
2) src.b = ref.b ; If condition not met - drop; If lookup failure - drop

Now if I have 2 rows in my source which is satisfying the above first condition, then what happens is that my job gets executed without any errors but 0 records are written in target.
whereas if I remove my 2nd constarint and then again run the job 2 records are written in target.
SO what I understand here is that datastge is checking for both the constarints at one time and if a record doesn't meet that requirement its dropping it. Where as what I want to achieve is if it meets any of these constraints then it should write that record to my target. Can anybody help me with this??
soumya5891
Participant
Posts: 152
Joined: Mon Mar 07, 2011 6:16 am

Re: Datastage

Post by soumya5891 »

You can do the both look up in continue,continue mode.Then in a filter check 1 and 2.If anyone of these satisfy then record will be passed.
Soumya
Post Reply