My Oracle Support Banner

IKM Oracle Slowly Changing Dimension Limitation (Doc ID 2687961.1)

Last updated on JULY 14, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and examples below and/or the attached documents, values represent a fictitious sample. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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:

 

 

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!

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