My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

Applies to:

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



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?


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

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