Which job do you want to add? Another sequential job or a parallel job? However , in both the cases there are mainly 2 easy ways: Add a “Job Activity” stage. Sequencer. Multiple inputs and multiple outputs. 11 here we are executing Trigger Stage that is job finished with no errors/ Warnings. Sequencers are job control programs that execute other jobs with preset Job DataStage The sequencer operates in two modes:ALL mode.
|Published (Last):||5 August 2017|
|PDF File Size:||5.32 Mb|
|ePub File Size:||16.70 Mb|
|Price:||Free* [*Free Regsitration Required]|
You will recall that sequencer jobs invoke and run other dxtastage. You can create a master sequencer job to invoke and run all the required sequencers that populate a specific fact tableor populate all fact tables for a given data mart, or all fact tables for an entire EPM warehouse.
For example, you can create a master sequencer job to automatically invoke and run 20 sequencer jobs from the Receivables mart. The master sequencer utility is available in the following DataStage folder: To create a master sequencer job using the master sequencer utility:.
Identify the individual sequencer jobs you want to include in the master sequencer job. The master sequencer utility uses only sequencer jobs as input; please do not use server jobs as input.
Examples of using the sequencer stage
Also, the sequencer jobs you select should be compiled and ready for use. Copy the list of sequencer jobs and paste the names into a text file.
Ensure that each job is entered on a separate line.
The master sequencer job uses the text file as an input and reads the list of sequencer jobs from the file. The file path you specify should be local to the datastqge do not specify a path to a client machine.
Note the file path of the text file for later use. In the Parameters tab, use the Enter Source text file Name field to enter the file path for the text file you created in step three.
Use the Enter the Jobname field to enter the name of the new datastqge sequencer job. Use the Choose the Master Sequence Type field to specify the mode in which you want the sequencer jobs to be run. Valid values are Parallel or Sequential.
Using the Master Sequencer Utility to Create Master Sequencer Jobs
Ensure you select the proper mode for the sequential jobs included in the master sequencer. Only staging sequencer jobs can be run in parallel.
Other dimension and fact datastagf may have dependencies and, unless those dependencies are identified and managed accordingly, we advise that you do not run them in parallel. Click the Run button to generate the master sequencer job.
This process generates the master sequencer job and stores it in the target file path you specified in dataetage seven. Hard-coded values in the sequencer job parameters are listed as warning messages in the log file. Import the generated master sequencer job into your DataStage project. If a master sequencer job with the same name already exists in the project, it is overwritten and placed in the same category.
Sequence job activities
If the master sequencer job does not exist in the project, it is placed in the following default location: Once the master sequencer job is imported into your project, you can move it to another category. The utility does not provide annotations for the master sequencer job, but you can provide annotations if you wish.
You must compile the master sequencer job before you can use it. Creating a Master Sequencer Job To create a master sequencer job using the master dahastage utility: