ODI Custom KM Ignored if Reusable Mapping is Joined with Dataset in Mapping (Doc ID 2767751.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.4, even though a custom KM is specified to be used as XKM, this is being ignored if a reusable mapping is used as source and joined with another table.
If there is no join with another table, the code is generated correctly using the custom KM.

ODI should generate the code using the specified KM.


The issue can be reproduced at will with the following steps:

1. In ODI Studio, create a reusable mapping with set component
2. Create a mapping and use the reusable mapping as source
3. In a dataset, join the reusable mapping with a datastore
4. Target to another table
5. In "Physical" tab, set the custom KM to be used as XKM
6. Run the mapping in simulation mode and observe that the custom KM is not used

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.