DSXchange

ray.wurlod wrote:Use a conditional lookup with an IsNotNull() condition on the lookup key in the stream input, and mark the Condition Failed rule Continue. ...

This worked like a charm!! :D
Thank you guys for your help

I have a lookup stage which has input records with null values. Basically I want the lookup stage to Reject records when there are unmatched records but continue when there are null values on the key. My input columns and receiving columns are nullable and Lookup Failure is set to 'Reject' Not sure ...

Hi , I am a newbie to datastage and stuck on this job since yesterday :( Can someone help me with this My data after transforming looks like below: JobId Status ------------------ 7859 Success 7859 Fail 7859 Success 7859 Success I want my output data to look like: JobId Success Fail ----------------...

Hey Craig,

Yes you were right!! It was running on 4 nodes. Changed it to 1 and its working fine now.
Thank you so much :D

I checked with a different Job id. Again the records are x4 times.
I noticed in SalesForce that there multiple logins when i executed the job.
I believe its logging in multiple times, getting the job id and returning me the records.

I have a question regarding Querying bulk load status (Salesforce Connector) in IBM Infosphere Datatstage. The query job is returning me duplicate records of my Salesoforce job. Basically returning records x4 times as there are total 4 batches in my job. I have 13 records (4 batches) processed in my...