DSXchange

Hi,

One of our job is processing only 5 rows per second, we have nearly 0.23 million source records and the update rule in the target is 'update existing rows only'.Can anyone pls help me out how to improve the performance of this jobs. i have disabled the index and constraints on the target table, but still getting 5 rows per second only.

Do you have an index on the key column? Disabling index in this case will slow down your job.

No i dont have indexcon the key column, do you suggest to create one?

senthilmp wrote:No i dont have indexcon the key column, do you suggest to create one?

Yes.

Thansk it works