The performance of tOracleSCD component is very slow 60 rows/s which is not acceptable. If there are millions of records then it costs more time to accomplish which is some thing not recommended. If the performance can be improved for this component then this will be one of the biggest advantage for Talend users.
We as DW/BI engineers deal with huge transfers of data from different data sources to different targets and we need to maintain the data, so if this is going to take long time for data transfers only then ultimately the decision making system will be slowed down which in turn decrease the profits of businesses
I hope you will find a solution to improve the performance of the component
Thanks and Regards,
Pavan
Hi Pavan
Please show us the screenshot of your job. Now the info is limited.
And remember to select "use memory saving mode" checkbox for better performance.
Regards,
Pedro
Hi Pedro,
Yes i have selected the check box "Use Memory Saving Mode", even though the performance is slow. For around 255,244 rows the job took around 1:20 (hh:mm).
Please find the attached screen shot of my job below.
Thanks and Regards,
Pavan
Hi Pedro,
But when i hover on the warning no description is defined, i mean for what the warning is displayed. How to check the warning? or what might be done to configure the component correctly?
Thanks and Regards,
Pavan
