How to Run SCD on Tables Which Reside on the Same Database but in a Different Schema Other ATOMIC Schema? (Doc ID 2260042.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.4.0.0 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 6.1 and later
Oracle Financial Services Asset Liability Management Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Slowly Changing Dimension (SCD)

Goal

Require to know how to run the SCD (Slowly Change Dimension) using OFSAA 7.3.4 on schema other than ATOMIC schema.
Have a business requirement to track all the changes on certain tables reside on schema X. The schema X is on the same database on OFSAA, but this schema is not ATOMIC schema.
How to use OFSAA- SCD to run on schema different than ATOMIC schema?

Solution

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 hundreds of Community platforms