MENU
The designer creates a replication task with the source schema name 'HR' and renames the schema in the following areas:
1. In Global Transformation, create a rule to rename schema to 'USER1'
2. In Task Settings -> Target Metadata, enter the Target table schema as 'USER2'
3. In Global Transformation, add a new column named 'SCHEMA' and expression as 'USER3'
Which is the final target schema name?
In Qlik Replicate, when multiple schema rename rules are applied, the final schema name is determined by the last applied setting that affects the schema name directly. Here's how the process works:
Global Transformation to rename schema to 'USER1': This rule will initially rename the schema from 'HR' to 'USER1'. However, this is not the final schema name as further changes are applied later in the task settings1.
Task Settings -> Target Metadata to enter the Target table schema as 'USER2': This setting overrides the previous global transformation rule and sets the target schema name to 'USER2'. This is because the Target Metadata settings are applied after the Global Transformations and directly affect the target schema name1.
Global Transformation to add a new column named 'SCHEMA' with expression as 'USER3': While this rule adds a new column with a value of 'USER3', it does not change the schema name itself. It only affects the content of a column within the tables1.
Therefore, the final target schema name, after considering all the applied settings, is D. USER2. This is because the Target Metadata setting in the task settings has the final say on the target schema name, and it is set to 'USER2'1.
Currently there are no comments in this discussion, be the first to comment!