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 OCTOBER 04, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.4.0 and laterInformation 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:
select DISTINCT
TABLE1.COLUMN1,
TABLE1.COLUMN2,
TABLE1.COLUMN3,...
from...
where...
- Code generated for same Mapping and LKM step, after having upgraded to ODI 12.2.1.4:
select
TABLE1.COLUMN1,
TABLE1.COLUMN2,
TABLE1.COLUMN3,...
from...
where...
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |