Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse > Administering the Informatica Repository >
Verifying Successful Loading of the Siebel Data Warehouse
To verify that Siebel Data Warehouse has loaded
- Look through the Monitor in the Workflow Manager as to whether the following Session SIL_CopyUpdatedRunTableToOLTP1 has been successfully completed.
- In the Siebel application, navigate to Data Warehouse Administration > ETL Run.
- The status should be "Completed." Use this SQL command to get more info: select * from W_ETL_RUN_S.
- Query the OLTP table S_ETL_RUN and check the status. Select status_cd from S_ETL_RUN. If the status is Completed, then the Data Warehouse has been successfully completed.
The status should be Completed. Use this SQL command to get more info: select * from S_ETL_RUN.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |