https://community.qlik.com/t5/Talend-Studio/Performance-improvement-in-SCD2-job/m-p/2258705#M40421 <P>Hello,</P><P>&nbsp;</P><P>I have created SCD2 job with Postgresql component(Redshift Database) for my target. I have to run the job for approx 120,000 records but the performance is very poor. Like 6 records/sec. IN this way the job will take ~16 hrs which is unacceptable. Is there any way I boost the performance of this job?</P><P>&nbsp;</P><P>There is just 1 attribute which is identified as SCD2 field. How do i improve the performance of this job without impacting my results.</P> Sat, 16 Nov 2024 02:25:05 GMT sushantk19 2024-11-16T02:25:05Z https://community.qlik.com/t5/Talend-Studio/Performance-improvement-in-SCD2-job/m-p/2258705#M40421 <P>Hello,</P><P>&nbsp;</P><P>I have created SCD2 job with Postgresql component(Redshift Database) for my target. I have to run the job for approx 120,000 records but the performance is very poor. Like 6 records/sec. IN this way the job will take ~16 hrs which is unacceptable. Is there any way I boost the performance of this job?</P><P>&nbsp;</P><P>There is just 1 attribute which is identified as SCD2 field. How do i improve the performance of this job without impacting my results.</P> Sat, 16 Nov 2024 02:25:05 GMT https://community.qlik.com/t5/Talend-Studio/Performance-improvement-in-SCD2-job/m-p/2258705#M40421 sushantk19 2024-11-16T02:25:05Z