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:

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

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