EPM :Need DMS Scripts To Backup Needed Dimension Rows And Setup Tables So We Can Rebuild Warehouse Tables (Doc ID 1923535.1)

Last updated on JUNE 14, 2017

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 and later
Information in this document applies to any platform.

Goal

Qn1:customer believe Oracle has EPM scripts to backup ALL needed data from the warehouse, truncate tables, and reload only the important rows in order for the warehouse to be rebuilt on fresh transactional data in a new IBM DataStage project. Had some scripts like this at a previous employer that customer think Oracle provided.

Could you please advise and provide the DMS scripts to perform the data cleansing, if any?
 
Qn2:what other tables need to be truncated for the refresh besides the fact and dimension tables? Can think of the PS_E_* (error tables), PS_X_*, PS_S_*, and PS_ES_*. Does missed anything else that needs to be truncated?
 

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