Tuesday, April 23, 2013

Multiple Job Compile in DataStage

Multiple job compilation is used to compile multiple jobs at a time. Follow the steps: 

Step 1: Log into DS Designer and go to 
‘Tools -> Multiple Job Compile’ 

Step 2: Then select job kind, routines or etc which you want to compile and choose Show Manual section page from the following diagram. 


Step 3: Move selected jobs or routines from Project contents to selected items as shown in the following figure 

Step 4: Choose Force Compile and Start Compile in the last window. 

Step 5: After completion of all selected jobs, a report will be generated by Data Stage if that option is checked. 


Advantages and disadvantages of using the Multiple Job compile are as follows: 

a) You can compile any number of jobs at a time. Just select the jobs you want to compile as shown above and you can attend to any other works. In the mean time, the compilation process will be going on in the background. 

b) One disadvantage of the multiple job compile is that this takes much more time when compared to compiling jobs individually. So I would suggest you to go for individual compilation if you need to compile only 2 or 3 

c) Another disadvantage is that you need to unhold the jobs as long as they are being compiled. If you try to open the jobs in midst, the compilation for that particular job will fail and you need to compile that job again. 

I suggest you to go for multiple Job compile when you need to compile jobs in bulk.

No comments: