DSXchange

Hi, You could make use of two Oracle enterprise stages in this scenario. Where in one should do the insert operation while the other does only delete operation. These stages should get input links from Transformer stage. In Transformer stage you can specify "link ordering" with "Seque...

hi Ray, I don't see any difference about my User ID against other User ID's. All our UserID's belong to same group on ETL box and privileges set are also the same. I was browsing through couple of tech forums and found that this is potentially an bug in Datastage and there is an patch readily availa...

hi All, Am using following job design. ExternalSourceStage ->TransformerStage->StoredProcedureStage->SQFileStage But this works fine with my ID. When I compile this job using different UserID and try to execute it gives Oracle-12154 TNS error on Stored Procedure stage. When I checked OSH script when...

hi, I have configured shell script which calls "dsjob" command to execute an Datastage job in the "Extrnal Source Stage". But, dsjob command after execution outputs below information. ------------------------------------------------------------------------- Finished waiting for j...

hi Chulett, Am trying to delete and insert huge volume of data on same table in the same job. I just extract all the data from Source system and compare this aganist Target table existing data. Based on comparision I just delete all the matching existing records from target table and insert all reco...

hi Chulett, In parallel jobs we cannot have 2 input links to Oracle Enterprise Stage. So, I just made use of single "Dynamic RDBMS stage" to do both "Delete and Insert" operation on the table. But still no luck as job used to try to insert data first and then try to delete. Which...

hi Ray, I apologize for not explaining you properly on what I was trying to do. I have two jobs , First job does deletion of data where as second job does insertion of data into same table. Am triggering second job from first job using a "after job subroutine(dsjob script)" because I need ...

hi Ray,

Do you have any suggestion on to how to handle Delete/Insert on Oracle database (Same table) in Parallel jobs.

Thanks & regards
Sudhindra P S

hi Arndw, We had raised the same thing with IBM sometime back. But, they came back saying we need to set both the properties to very high level to get those properties work efficiently. I just tested them with high values and it works fine (in the sense whenever Job aborts the transaction gets rolle...

hi Chulett, Thanks for replying to my query. The problem with performing Delete and Insert in the same job would lead to different complexities which we have faced, such as (1) Sometimes tables were getting into a "Dead Lock" issue. (2) Sometimes job was getting hanged as both Delete and I...

hi Chulett, I have two ETL jobs one for delete and one for Insert. Am performing delete first in the first ETL job and am calling a second ETL job from "after job subroutine" to do the data insert into the table. Incase if second job fails then I have to rollback the delete operation what ...

hi Chulett, I have two ETL jobs one for delete and one for Insert. Am performing delete first in the first ETL job and am calling a second ETL job from "after job subroutine" to do the data insert into the table. Incase if second job fails then I have to rollback the delete operation what ...

hi, I have shell script invoked from "After job Subroutine" which throws back the success/failure status based on some logic. Now, when script throws back failure status(i.e exit 1) job isn't getting aborted rather it just says "Warning Message" as mentioned below. --------------...

hi Eostic, Thanks for the resolution you have provided. I was able to wrap up both Oracle Stored Procedures and ETL webservices as one component using Java programming language as a wrapper script. This tends to give good performance in terms of invoking both Oracle Stored Procedures and ETL jobs as...

hi,

As Eostic said it is better to leave the ports default as they are, rather than trying to manipulate them. I just had to default the ports as they are and it is said to be configured and working as expected to.

Thanks & regards
Sudhindra P S