Can We Avoid Truncating Of Enterprise And MCAL Tables In Incremental Loads?

(Doc ID 2209144.1)

Last updated on OCTOBER 16, 2017

Applies to:

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

Goal

How to avoid Truncating of Enterprise and MCAL tables in Incremental Loads?

IFor example, if you are planning to run the ETL loads 8 times in day,during which the few tables related to calendar getting truncated due to which reports are returning null values.
Is there any work around to avoid truncation of below tables same as W_DAY_D(Avoid Truncating W_DAY_D in incremental load ER: 18007645)

W_ENT_PERIOD_D
W_ENT_YEAR_D
W_ENT_QTR_D
W_ENT_WEEK_D
W_MCAL_DAY_D
W_MCAL_QTR_D
W_MCAL_YEAR_D
W_MCAL_WEEK_D
 

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