ETL Job Process Flow
This table provides answers to questions about the ETL job process flow.
Question |
Answer |
---|---|
How does EPM manage the process flow for ETL jobs? How are job interdependencies managed? |
DataStage Sequence job allows you to specify several jobs to run in controlled manner and can be used to specify different courses of action to take depending on whether a job in the Sequence succeeds or fails. Every ETL load has a Sequence job and each business process within a datamart is provided with a master sequence to trigger all the jobs belonging to it. See Using the Master Sequencer Utility to Create Master Sequencer Jobs. |
What are the common triggers used in the process flow? |
Triggers are used to control the flow of a Sequence job in triggering various other Sequence/Server child jobs. The most commonly used ones are
|