DSXchange

Thank you for the reply! The settings you asked about are: Array_Size = 32,767 Trans_Size = 0 Transaction Isolation Level = Insert without clearing or Transaction Isolation Level = Update existing rows only I reran the job using 1 & 1, and no Hash file, and it only took seconds to run! Could you...

Hi Everyone, Just wanted to see what people thought of this. I have a Datstage 8.1 Server job. The source is Oracle, and the target is Oracle. The source and target are on 2 different DB servers. The job reads from a DRS Stage, and then looks up against a Hash file to determine Inserts, and updates....