Constraints on Simple Journalization and Updates of Primary Key Fields in ODI
(Doc ID 424071.1)
Last updated on OCTOBER 04, 2022
Applies to:
Oracle Data Integrator - Version 3.2.03.01 and laterInformation in this document applies to any platform.
Goal
After having activated Simple Journalization on a Datastore, the Journal table does not appear to reflect the changes that have been applied to the Journalized Datastore.
The problem is that an application automatically updates the data of my journalized Datastores and the updates are performed on columns that compose the Primary Key of my Datastore.
As a result, the content of the Journal table is incorrect.
The Primary Key is defined in the Oracle Data Integrator (ODI) Repository and not necessarily in the database.
Solution
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
| Goal |
| Solution |
| References |