File to Netezza Function odiRef.getTable("FK_PK_TABLE_NAME") Shows Different Results in 11g Than in 12c
(Doc ID 2682592.1)
Last updated on OCTOBER 04, 2022
Applies to:Oracle Data Integrator - Version 184.108.40.206.190415 and later
Information in this document applies to any platform.
After upgrading to ODI 220.127.116.11.190415 it is observed that a mapping with File to Netezza using function odiRef.getTable("FK_PK_TABLE_NAME") returns a different value in ODI 12c than it did in ODI 18.104.22.168
Issue can be confirmed with the following steps
Run the mapping in simulation mode and compare the output for ODI 12c and 11g.
Notice the value attributed as FK_TABLE is different in ODI 12c than it was in 11g.
'TABLE_d' as FK_TABLE
'TABLE_d_v' as FK_TABLE
Upgrade ODI 22.214.171.124 to ODI 126.96.36.199.190415
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