You cannot configure partitioning when you use the advanced relationship option.

You must specify double quotes for the table name when you use a reserved word for the table name and the column name.

You cannot use a self join when you add multiple source objects.

When you use special characters in column names for an advanced relationship, the query formed is not correct and the mapping task fails.

When you click

Add Object

to add more objects in the

Advanced Relationship

window, the table might not load or take a lot of time to load. Import the object again.

You cannot search for a schema when you add a related source object. You must scroll down and manually select the schema.

You can use the full outer-join condition only with the

=

,

,

, and

AND

operators.

When you use the advanced relationship option and specify the join queries with the schema name override, the mapping fails. The mapping fails with the following join queries:

inner join
left outer-join
right outer-join
full outer-join
cross join

When you override the schema name and configure an advanced filter on a related source object, you must specify the schema name in the filter condition. Use the following syntax for the filter condition:

When you override the schema name and configure an advanced filter on a related source object, the Secure Agent applies the advanced filter only on the parent object and not on the related source object.

When you select the

Multiple Objects

source type, add a source object, for example,

emp

, and define a primary key and foreign key relationship on different columns, for example,

emp.id

and

dept.d_id

, the mapping fails with the following error:

When you select the

Multiple Objects

source type, ensure that the selected table names do not contain a period (.).