How to stop SDE_ORA_PROJECTCLASSIFICATION Dimension to be Truncated and Reloaded Every Time (Doc ID 2190452.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.2 and later
Information in this document applies to any platform.

Goal

Qn1:OBIA 11.1.1.9.2
SDE_ORA_PROJECTCLASSIFICATION Dimension


While running SESS_445420550_SDE_ORAR122_ADAPTOR_SDE_ORA_PROJECTCLASSIFICATION in multiple source instance. This dimension is truncated and reloaded every time.

The OOTB has truncate and load login init. Is there any reason doing it?


While running this Dimension its truncating and loading.. it is not possible to see data for multiple sources.

Current Behavior : Truncating and loading
Expected Behavior: Not to truncate every time
 
Qn2:Does this mean dimension will be reload every time even if the loads are daily incremental?
 

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