|Bookshelf Home | Contents | Index | PDF|
This section provides guidelines on what to do in the event of an Extract, Transform, and Load (ETL) failure. For example, the ETL process fails if a required file is missing or the PowerCenter Server is shut down because of memory problems. You can restart the ETL process in various workflows and worklets—Initialize, Prepare, Extract Facts, Extract Dimensions, Load Dimensions, Load Facts, and Post-Load Processing.
You can resume a workflow after investigating and resolving the issue that causes the suspended workflow. For example, a workflow fails because of a missing source file. In this scenario, you can provide the missing file and resume the workflow.
However, some workflow failures require changes to the session properties. You need to make the required changes to the session properties, save the changes in the repository, and resume the suspended workflow. If the workflow fails with your new changes, abort the workflow, and restart the workflow from the task.
You can restart the PowerCenter Server, and restart the workflow from the task, after investigating and resolving the issue that causes the workflow to fail. For example, a workflow fails and the PowerCenter Server is shut down because of memory problems.
|Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide|