Incorrect DML Generated for ODI Mapping with LEFT JOIN (Doc ID 2486900.1)

Last updated on AUGUST 31, 2023

Applies to:

Symptoms

In ODI 12.2.1.3.0, when attempting to run a mapping that contains a reusable mapping containing a left join, the following error occurs.

The issue can be reproduced with the following steps:

1. Create a reusable mapping that has in it one or two inner joins.
2. Create a mapping that uses the above reusable mapping and run it. It will complete successfully.
3. Change one inner join into a left one by checking the box for left join.
4. Run the mapping again and observe the error.

Cause