My Oracle Support Banner

IKM Oracle Slowly Changing Dimension Limitation (Doc ID 2687961.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 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!


In this Document
Symptoms
Changes
Cause
Solution
References


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