DataStage Jobs

Before we begin understanding what DataStage jobs are, let us first see how we can connect and login to the DataStage Designer.

DataStage Projects

We always enter DataStage through a DataStage project that have been setup using the Administrator. When we start the Designer or the Director clients of DataStage we are prompted to attach a Project from a drop down list. Unless a project is defined we will not be able to login to either the Designer or the Director
Each project will have the following details:

• DataStage jobs
• Table Definitions and Connection details
• Job Parameters
• Built-in Componenets
• Routines and other user-defined components

Once the Project is setup, we have to login to the DataStage Designer to create our first job

Step1: Opening the Designer:

To open the Designer, select Start->All Programs->IBM Information Server-> IBM InfoSphere DataStage and QualityStage Designer. It will open the following dialog box

Domain – server IP address or name on which the DataStage server is installed

Username and Password for connecting to the server

Project – Select the Project from those available in the drop down list

As show in the previous chapter this will open a graphical user interface for use to create jobs

When we select a new job, the following options are displayed to select the kind of job we want to develop.

DataStage Jobs

DataStage jobs are those which contain individual stages linked together to enable extraction transformation and loading of data from source to target.

The different job types available on DataStage are :

1. Parallel Jobs – Process multiple rows of data simultaneously and have a lot of advanced features from performing transformations

2. Server Jobs – Process a single row/record at time and have fewer stages compared to Parallel Jobs

3. Job Sequence – These are special jobs that are used to control the flow of either parallel jobs or server jobs. The stages in sequencers are called “Activities”

Select the Parallel job and a new job is create with a blank canvas over which we can drag stages, along with this repository and palatte are also made available

Now select File->Save option to save the job. The following popup will be displayed

1->From the repository, select the folder to which you want to save the job to


2->Once you select the folder the entire path of of the folder will be displayed on “Folder Path”


3->Enter the name of the job with which you wish to save it in “Item name:”


4-> Click on “Save” button and the job will be saved to the corresponding folder.