EPM 9.1 :Need Advice On Doing Data Stage 8.5 project refreshes from other environments (Doc ID 1544729.1)

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise EPM Financials Warehouse - Version 9 and later
Information in this document applies to any platform.

Goal

Qn:In our environment, we have a TST, QAT and PRD environment for each project. In a normal scenario, developers develop ETLs in TST, and move them up to QAT and then on to PRD. In general, we ask the developers to export their "in-progress" work from the lower instances before a refresh. If we were to do a refresh from PRD to TST or QAT, and we copied the whole project from PRD down to the lower instances with a filesystem copy, what tables from the metadata repository would we need to export/copy from PRD to the lower instance? And if there was hostname specific information in those tables, couldn't we just do a find/replace? We do similar things with our PeopleSoft refreshes, so that is why I'm asking. Please let me know.

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