Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jun 19, 2024 7:07:15 AM
Jun 19, 2024 7:07:15 AM
Parallel Load is often used to accelerate the replication of large tables by splitting the table into segments. Primary Key (or index) columns are not mandatory for Parallel Load; any column(s) can be used as a segment column as long as it can divide the data into segments. However, ROWID can sometimes be more efficient if the table has no Primary Key, no other indexes, and no other columns that can easily split the table rows.
Currently, Oracle data types ROWID/UROWID are not supported in the major versions of Qlik Replicate. As a result, columns with these data types will not be visible in the Qlik Replicate GUI, making it impossible to utilize ROWID directly in the Parallel Load design window.
This article provides a guide on how to utilize ROWID in Parallel Load.
CREATE VIEW scott.kitv1000rowid AS SELECT rowid||'' AS row_id, id, name, notes FROM scott.kitnopk1000 ORDER BY row_id;