hello Friends,
i have created a very simple SCD2 job. Its design is
tDBInput--->tmap-->tPostgresqlSCD component.
There are 2 fields identified in it as SCD2(as per business requirement) and 1 source key column.
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?
