Migrate mappings containing advanced filter and a table name override
Migrate mappings containing advanced filter and a table name override
If the mapping contains an advanced filter for the object, for example, <Table2>, in the query options section and an override to the table name in the advanced properties, consider the following rules to override the table:
In mappings, consider one of the following options:
The advanced filter in the mapping must include the
$$Filtercondition
value. In the mapping task, you can override the value from the parameter file in the task properties. The parameter condition in the parameter file must include the following condition:
$$Filtercondition =<Table2>.id >= 1
Use the table name that you specify as an override in the advanced properties directly in the advanced filter condition. For example,
<Table2>.id >= 1
.
In advanced mode, use the table name specified as an override in the object advanced properties directly in the advanced filter condition. For example,