QREP practice question 3 of 15

A Qlik Replicate administrator is working on a database where the column names in a source endpoint are too long and exceed the character limit for column names in the target endpoint. How should the administrator solve this issue?

Full set: 60 questions
Answer options
A: Open the Windows command line terminal and run the renamecolumn command to update all affected columns of all tables
B: Visit the Table Settings for each table in a task and select the Transform tab to update all affected columns within the Output pane
C: Visit the Table Settings for each table and select the Filter tab to update all affected columns using a record selection condition
D: Define a new Global Transformation rule of the Column type, and follow the prompts to filter and rename all columns in all tables Correct answer
Correct Answer:
D. Define a new Global Transformation rule of the Column type, and follow the prompts to filter and rename all columns in all tables
Explanation

Global Transformations in Qlik Replicate are designed to apply a single rule to multiple tables within a task, making it the most efficient method for widespread changes. To address excessively long column names, an administrator can create a "Rename Column" transformation. This rule can be configured to apply to all tables (or a subset matching a pattern) and rename columns based on specified criteria, such as using a function to truncate the name, thereby solving the issue systematically without manual, table-by-table intervention.

Why Incorrect

A. Qlik Replicate management is primarily performed through its user interface. While command-line utilities exist, a renamecolumn command for bulk updates is not the standard or recommended procedure for this task.
B. While the Transform tab in Table Settings can rename columns, this approach is inefficient as it must be applied manually to each affected column in every single table, which is not scalable.
C. The Filter tab is used for filtering rows (records) based on data conditions, not for renaming or transforming column metadata. This option is functionally incorrect for the stated problem.

References

1. Qlik Replicate User Guide (November 2023), "Transforming data on the fly," Page 219, Section: "Global transformations". This section states, "Global transformations allow you to apply transformation rules to multiple tables in a task... This is especially useful when you need to apply the same rule to many tables."

2. Qlik Replicate User Guide (November 2023), "Defining global transformations," Page 221, Section: "Rename column". This section details the procedure for creating a global rule to rename columns, confirming it as a primary feature. It describes how to select the schema, table, and column(s) to be renamed, supporting the application of a single rule across multiple objects.

3. Qlik Replicate User Guide (November 2023), "Defining transformations for a single table," Page 239, Section: "The Transform tab". This section describes the per-table transformation process, which corroborates why option B is less efficient for a task-wide issue. It states, "You can add, remove, and modify columns in a specific table."

Scroll to Top