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?
There is just 1 attribute which is identified as SCD2 field. How do i improve the performance of this job without impacting my results.
