Five Stars

Best practices for using SCD

I am using tPostgresqlSCD. 
The performance is really slow. It inserts 1 row per second or even slower. 
Is there anyway to increase the peformance of it?
I tried 'Use memory saving modes'. Which makes it even slower. 
I am inserting around 9000 rows in a 5 million rows dimension. 
I even have much bigger dimensions also. 
3 REPLIES
Moderator

Re: Best practices for using SCD

Hi,
Could you please post your current job design screenshots into forum? Did you use any  cache component in your work flow?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Best practices for using SCD

I am attaching screenshot. 
What do you mean by cache component? 
Five Stars

Re: Best practices for using SCD

I created an index on my source key it helped a little bit and made it faster. 
Does it help to put indexes on SCD 2 columns as well?