DSXchange

Anyone please tell, why DS parallel job is keep on running when I select UPSERT method. If I select Load only, it runs fine. Here I am giving update with condition two fields out of 26 of incoming records should match with existing records and also enddate should be greater than system date. And the...

Hi All, I am trying to implement SCD type 2, like following way. But the problem is, Record gets duplicated and can't add new record I am doing like this. 1. Datas are comin from sequential file and giving the Surrogate Key by Surrogate Key Generator, then make look up table after reading from oracl...

Hi, I am trying to load datas from sequential to Oracle thru' Oracle Enterprise, I am getting error Oracle_Enterprise_2,0: system(sqlldr cdrdwadm CONTROL=ora.7716.433297.0.ctl LOG=ora.7716.433297.0.log BAD=ora.7716.433297.0.log.bad SILENT=header PARFILE=ora.7716.433297.0.par ) failed. See log file f...

Hi,

Any one please give information what would be DataStage administrator roles other than DS developers work.

Thanks.

IOWAjax

Hi all, Can anyone enlight whether, is there any way to know PX Resource Consumption, and then changing PX stages to achive minimum resource consumption by the partcular PX job (e.g. to process 100m rows). I am kind of curious to know the answer. (other details: 8 CPU, AIX 5.x). I checked earlier po...

Hi,

Could anyone throw light briefly on how to migrate data stage jobs into production environment.

Thank you in advance.

iowaJAK