DSXchange

Hi Every one, I am working on Datastage PX 8.1 in Unix env. I would like to know what is the differences b/w oracle connector and Oracle enterprise stage in PX. Both are working in parallel. I am finding difficulty to understand what are the main difference between both and in terms of performance a...

Hi, I have a requirement like if the records and getting dropped while loading the target oracle table using Oracle OCI stage in Datastage Px 8.1 the job should fail. I am not using the reject property of the stage, but if any records are silently dropping because of NULL constraints or anything , t...

Hi, First time I am posting a topic. I am facing some issue with Oracle OCI stage commit in Datastage 8.1 PX. My requirement is while doing an upsert either commit all the records if job successful or not to commit any records if job aborts. I came to know that this can be achieved by changing the A...