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
performance tuning process
Moderators: chulett, rschirm, roy
performance tuning process
thanks n regards
nani
nani
-
- Participant
- Posts: 6
- Joined: Fri Jun 15, 2007 4:53 am
go to properies tabs and go to options and add the number
go to properies tabs and go to options and add the number of readers per nodes
Re: performance tuning process
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.
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.
Re: performance tuning process
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.
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.