Post Upgrade to ODI 126.96.36.199 the SELECT Query Implemented by LKM Task is Missing the DISTINCT Clause
(Doc ID 2673340.1)
Last updated on OCTOBER 04, 2022
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
After having upgraded from Oracle Data Integrator (ODI) 11g to ODI 184.108.40.206, Mappings using the getPop("DISTINCT_ROWS") substitution method in LKM steps:
... no longer generate the DISTINCT clause. Note however that the DISTINCT clause continues to be generated in the IKM steps.
- Code generated by the LKM step in ODI 11g:
- Code generated for same Mapping and LKM step, after having upgraded to ODI 220.127.116.11:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document