IKM Oracle Slowly Changing Dimension Limitation
(Doc ID 2687961.1)
Last updated on JULY 13, 2020
Applies to:Oracle Data Integrator - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
When having multiple historical records for the same natural key in the source table, IKM Oracle Slowly Changing Dimension doesn't handle the records correctly.
For example, the source table contains new records like below:
The SCD behaviour is set in target table:
When running a mapping to transfer data from source to target using IKM Oracle Slowly Changing Dimension, this is the incorrect result:
But this should be the correct result:
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