https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372907#M135693 Hi Pedro, <BR />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). <BR />Please find the attached screen shot of my job below. <BR />Thanks and Regards, <BR />Pavan Wed, 16 May 2012 12:01:27 GMT Anonymous 2012-05-16T12:01:27Z https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372905#M135691 Hi Team, <BR /> <BR />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. <BR />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 <BR />I hope you will find a solution to improve the performance of the component <BR />Thanks and Regards, <BR />Pavan Wed, 16 May 2012 10:38:44 GMT https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372905#M135691 Anonymous 2012-05-16T10:38:44Z https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372906#M135692 Hi Pavan <BR />Please show us the screenshot of your job. Now the info is limited. <BR />And remember to select "use memory saving mode" checkbox for better performance. <BR />Regards, <BR />Pedro Wed, 16 May 2012 10:43:17 GMT https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372906#M135692 Anonymous 2012-05-16T10:43:17Z https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372907#M135693 Hi Pedro, <BR />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). <BR />Please find the attached screen shot of my job below. <BR />Thanks and Regards, <BR />Pavan Wed, 16 May 2012 12:01:27 GMT https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372907#M135693 Anonymous 2012-05-16T12:01:27Z https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372908#M135694 Hi Pavan<BR />There is a yellow warning at the top-right corner of tOralceInput.<BR />You'd better check it.<BR />Regards,<BR />Pedro Thu, 17 May 2012 02:39:51 GMT https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372908#M135694 Anonymous 2012-05-17T02:39:51Z https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372909#M135695 Hi Pedro, <BR />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? <BR />Thanks and Regards, <BR />Pavan Thu, 17 May 2012 05:18:03 GMT https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372909#M135695 Anonymous 2012-05-17T05:18:03Z https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372910#M135696 Hi Pavan<BR />Please show us the settings of tMSSQLInput.<BR />Regards,<BR />Pedro Thu, 17 May 2012 06:56:33 GMT https://community.qlik.com/t5/Talend-Studio/Improve-the-Performance-of-tOracleSCD-component/m-p/2372910#M135696 Anonymous 2012-05-17T06:56:33Z