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

1. Look through the Monitor in the Workflow Manager as to whether the following Session SIL_CopyUpdatedRunTableToOLTP1 has been successfully completed.

   The monitor should show that it is completed.

2. In the Siebel application, navigate to Data Warehouse Administration > ETL Run.
   • If the ETL process completed successfully, the final record in the applet shows the status Completed.
   • If the ETL process did not complete successfully, the final record in the applet shows the status Running.
3. The status should be "Completed." Use this SQL command to get more info: select * from W_ETL_RUN_S.
4. 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