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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates

Improving performance on Replicate Target Apply

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
KellyHobson
Former Employee
Former Employee

Improving performance on Replicate Target Apply

Last Update:

Mar 17, 2022 8:20:53 AM

Updated By:

KellyHobson

Created date:

Mar 17, 2022 8:20:53 AM

Within Task Settings -> Change Process -> Change Process Tuning

There is a setting called: Apply batched changes to multiple tables concurrently

When you select this, it should improve performance when applying changes from multiple source tables. The default is five, the maximum is 50, and the minimum is two

This is supported on Snowflake on Azure, Snowflake on AWS, Snowflake on Google, Microsoft SQL Server, Amazon Redshift, Microsoft Azure Databricks Delta, Microsoft Azure Synapse Analytics, and Microsoft Azure SQL Database.

Please see limitations:

https://help.qlik.com/en-US/replicate/November2021/Content/Global_Common/Content/SharedEMReplicate/C...

 

Environment

 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Contributors
Version history
Last update:
‎2022-03-17 08:20 AM
Updated by: