performance tuning process

[nani0907]

Hi all,

i am having source as file with huge amount of data. it's taking along time to run the job to get loaded into the targetdatabase which is oracle.
Could you please let me know how to finetune the performance

Thanks In Advance

[Divya.A]

In order to have faster reading from the Stage the number of readers per node can be increased (default value is one).

[Divya.A]

In order to have faster reading from the Stage the number of readers per node can be increased (default value is one).

[nani0907]

hi,

Could you please tell me how set the readers option and where can i find it

[balu_infotech]

go to properies tabs and go to options and add the number of readers per nodes

[nani0907]

Thanks.

This is the part of tuning at the source level for the file. and how to improve the performance while it is inserting into the target table which is oracle as it is taking the long time

[Romy]

Hi,

I am not sure whether you are using any index in the target table. If so drop it, insert the data and then re create the index again. It may improve the performance.

[pratimdc]

Try using Load option in the Oracle stage.

If you can not disable the indexes then use the option DIRECT=FALSE. If you have persmission to disable and enable indexes then you may use DIRECT=TRUE.

This should improve your performance.