EPM :Need DMS Scripts To Backup Needed Dimension Rows And Setup Tables So We Can Rebuild Warehouse Tables
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.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms