Post Upgrade to ODI 12.2.1.4 the SELECT Query Implemented By LKM Task Is Missing the DISTINCT Clause
(Doc ID 2673340.1)
Last updated on DECEMBER 20, 2023
Applies to:
Oracle Data Integrator - Version 12.2.1.4.0 and laterOracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.
Symptoms
After having upgraded from Oracle Data Integrator (ODI) 11g to ODI 12.2.1.4, Mappings using the getPop("DISTINCT_ROWS") substitution method in LKM steps:
<%=odiRef.getPop("DISTINCT_ROWS")%>
... no longer generate the DISTINCT clause. Note however that the DISTINCT clause continues to be generated in the IKM steps.
For example:
- Code generated by the LKM step in ODI 11g:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |