https://community.qlik.com/t5/Talend-Studio/improving-performance-of-SCD2-job/m-p/2300590#M72803 <P>hello Friends,</P><P>i have created a very simple SCD2 job. Its design is </P><P></P><P></P><P>tDBInput---&gt;tmap--&gt;tPostgresqlSCD component.</P><P>There are 2 fields identified in it as SCD2(as per business requirement) and 1 source key column.</P><P></P><P></P><P>When i run this job, it runs with a very low throughput like 1 row/s whereas a similar job created by me with 4 fields as SCD2 runs at a decent throughout of 4 rows/s. what could be possible reason for this low throughput? is this a normal behavior? how can i improve the throughput of this job?</P> Sat, 16 Nov 2024 01:16:44 GMT sushantk19 2024-11-16T01:16:44Z https://community.qlik.com/t5/Talend-Studio/improving-performance-of-SCD2-job/m-p/2300590#M72803 <P>hello Friends,</P><P>i have created a very simple SCD2 job. Its design is </P><P></P><P></P><P>tDBInput---&gt;tmap--&gt;tPostgresqlSCD component.</P><P>There are 2 fields identified in it as SCD2(as per business requirement) and 1 source key column.</P><P></P><P></P><P>When i run this job, it runs with a very low throughput like 1 row/s whereas a similar job created by me with 4 fields as SCD2 runs at a decent throughout of 4 rows/s. what could be possible reason for this low throughput? is this a normal behavior? how can i improve the throughput of this job?</P> Sat, 16 Nov 2024 01:16:44 GMT https://community.qlik.com/t5/Talend-Studio/improving-performance-of-SCD2-job/m-p/2300590#M72803 sushantk19 2024-11-16T01:16:44Z https://community.qlik.com/t5/Talend-Studio/improving-performance-of-SCD2-job/m-p/2300591#M72804 <P>Hello Friends,</P><P>&nbsp;</P><P>Any inputs/suggestions on the above scenario??</P> Fri, 30 Oct 2020 08:39:58 GMT https://community.qlik.com/t5/Talend-Studio/improving-performance-of-SCD2-job/m-p/2300591#M72804 sushantk19 2020-10-30T08:39:58Z