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 APRIL 09, 2021
Applies to:Oracle Data Integrator - Version 126.96.36.199.190415 and later
Information in this document applies to any platform.
After upgrading to ODI 188.8.131.52.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 184.108.40.206
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 220.127.116.11 to ODI 18.104.22.168.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