Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dwhdeveloper
Contributor
Contributor
‎2017-03-08 10:13 AM

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. 
Labels (2)
Labels
305 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2017-03-10 04:01 AM

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
305 Views
0 Likes
dwhdeveloper
Contributor
Contributor
‎2017-03-13 10:15 AM
Author

I am attaching screenshot. 
What do you mean by cache component? 
0683p000009MDWg.png 0683p000009MDPs.png 0683p000009MCfj.png 0683p000009MDZy.png
305 Views
0 Likes
dwhdeveloper
Contributor
Contributor
‎2017-03-20 09:40 AM
Author

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? 
305 Views
0 Likes