Skip to Main Content
Return to Navigation

Reviewing Delivered ETL Jobs and Data Warehouse Tables

To review the delivered ETL jobs and data warehouse tables:

  1. Begin by evaluating your own internal source tables and planning your approach.

  2. Use PeopleTools Application Designer to review the OWS tables and data warehouse tables that are delivered with EPM. Determine how to structure your system to best fit the needs of your organization.

  3. Evaluate the ETL jobs that are delivered with the IBM WebSphere DataStage Project and determine whether they are properly configured to meet the needs of your organization.

  4. See My Oracle Support for a listing of table-loading sequences for mapping PeopleSoft application data to the OWS tables and data warehouse tables.

Warning! Any changes that you make to the delivered data warehouse tables have the potential to affect Application Engine processes and PeopleCode processing throughout the system. Evaluate and make these types of changes very carefully.