Skip to main content

Under what conditions to transform

In the Under what conditions to transform? step of the New Transformation Rule wizard, you define to which tables the transformation rule is applied. For example, you can apply the rule to all tables that contain the word SALARY as part of its name.

Note:

The options displayed in this screen depend on the Transformation Type selected.

The following table describes all available options. The second column lists the Transformation Type(s) required for the option to be available.

Transformation conditions
Option Required Type Description

Schema name is like %

Always

Leave the % sign to include all schemas in your global transformation.

Click the % sign to add a filter. In this case you can enter any name combination to include only that schema in your global transformation rule.

For example, enter HR to include only tables that have the schema HR.

You can use the % sign as a wildcard. For example, H% includes all tables with a schema that begins with the letter H, such as HR, HELLO, or HQ.

The % wildcard can be used in any position. For example, if you use it at the beginning, %H, then all table names that end in H are included in the transformation rule. The % can also be used in a middle position.

Note:

If you are using an Oracle target, you must enter a schema that exists on the target endpoint. Qlik Replicate does not create new schemas on an Oracle endpoint. If you want to use a new schema for the target, create the schema on the Oracle endpoint before running the task. For more information, see Using Oracle as a target.

Table tablespace is like %

Change table tablespace

Note:

This option is only available if the task is defined with an Oracle target endpoint.

Leave the % sign to include all table tablespace names in your global transformation.

Click the % sign to add a filter. In this case, you can enter any name combination to include only the specified table tablespace in your global transformation rule.

For example, enter SYSTEM to include only table tablespaces called SYSTEM.

You can also use the % sign as a wildcard anywhere in the string. For example, H% includes all table tablespaces that begin with the letter "H" whereas %H includes all table tablespaces that end with the letter "H".

Index tablespace is like %

Change index tablespace

Note:

This option is only available if the task is defined with an Oracle target endpoint.

Leave the % sign to include all index tablespace names in your global transformation.

Click the % sign to add a filter. In this case, you can enter any name combination to include only the specified index tablespace in your global transformation rule.

For example, enter SYSTEM to include only index tablespaces called SYSTEM.

You can also use the % sign as a wildcard anywhere in the string. For example, H% includes all index tablespaces that begin with the letter "H" whereas %H includes all index tablespaces that end with the letter "H".

Table name is like %

Always

Leave the % sign to include all table names in your global transformation rule.

Click the % sign to add a filter. In this case you can enter any name combination to include only tables with that specific name in your global transformation rule.

You can use the % sign as a wildcard. For example, J% includes all tables with a name that begins with the letter J, such as JOBS, JOBS_HISTORY, or JACKSONVILLE.

The % wildcard can be used in any position. For example, if you use it at the beginning, %H, then all table names that end in H are included in the transformation rule. The % can also be used in a middle position.

Column name is like %

Rename Column

Drop Column

Convert Data Type

Leave the % sign to include all column names in your global transformation rule.

Click the % sign to add a filter. In this case you can enter any name combination to include only columns with that specific name in your global transformation rule.

You can use the % sign as a wildcard. For example, N% includes all columns with a name that begins with the letter N, such as NAME, NAME_FIRST, or NAME_LAST.

The % wildcard can be used in any position. For example, if you use it at the beginning, %IES, then all column names that end in with the string "IES" are included in the transformation rule. The % can also be used in a middle position.

Data type is

Convert Data Type

Select a new data type from the drop-down list. Make sure that the data type you select is compatible with the data in that column.

For a description of Qlik Replicate data types, see Replicate data types.

For information about data type mapping from the native endpoint to Qlik Replicate data types, see the chapter for the endpoint you are using. For a list of endpoints supported by Qlik Replicate, see Supported Platforms and Endpoints.

After you complete defining the transformation rule definitions, click Next to go to the Defining the transformation rule step.

Note:

If the global transformation type you are defining is Drop Column, you do not need to create a Transformation Rule. In this case, click Finish to add the rule to the Global Transformation Rules list.