Jobs are designed and developed using the Designer. The job design is developed in the Diagram window (the one with grid lines). Each data source, the data warehouse, and each processing step is represented by a stage in the job design. The stages are linked together to show the flow of data.

For Example we can develop a job with the following three stages:

A Universe stage to represent EXAMPLE1 (the data source).

A Transformer stage to convert the data in the DATE column from an YYYY-MM-DD date in internal date format to a string giving just year and month (YYYY-MM).

A Sequential File stage to represent the file created at run time (the data warehouse in this example).

Adding Stages:

Stages are added using the tool palette. This palette contains icons that represent the components you can add to a job. The palette has different groups to organize the tools available.

To add a stage:

    1. Click the stage button on the tool palette that represents the stage type you want to add.
    2. Click in the Diagram window where you want the stage to be positioned. The stage appears in the Diagram window as a square. You can also drag items from the palette to the Diagram window.
We recommend that you position your stages as follows:
Data sources on the left
Data warehouse on the right
Transformer stage in the center
When you add stages, they are automatically assigned default names. These names are based on the type of stage and the number of the item in the Diagram window. You can use the default names in the example.
Once all the stages are in place, you can link them together to show the flow of data.
Linking Stages
You need to add two links:
  • One between the Universe and Transformer stages
  • One between the Transformer and Sequential File stages
Links are always made in the direction the data will flow, that is, usually left to right. When you add links, they are assigned default names. You can use the default names in the example.
To add a link:
  1. Right-click the first stage, hold the mouse button down and drag the link to the transformer stage. Release the mouse button.
  2. Right-click the Transformer stage and drag the link to the Sequential File stage. The following screen shows how the Diagram window looks when you have added the stages and links:
Editing the Stages
Your job design currently displays the stages and the links between them. You must edit each stage in the job to specify the data to use and what to do with it. Stages are edited in the job design by double-clicking each stage in turn. Each stage type has its own editor.
Editing the UniVerse Stage
The data source (EXAMPLE1) is represented by a UniVerse stage. You must specify the data you want to extract from this file by editing the stage.
Double-click the stage to edit it. The UniVerse Stage dialog box appears:
This dialog box has two pages:
Stage. Displayed by default. This page contains the name of the stage you are editing. The General tab specifies where the file is found and the connection type.
Outputs. Contains information describing the data flowing from the stage. You edit this page to describe the data you want to extract from the file. In this example, the output from this stage goes to the Transformer stage. To edit the Universe stage:
  1. Check that you are displaying the General tab on the Stage page.

Choose localuv from the Data source name drop-down list. Localuv is where EXAMPLE1 is copied to during installation.

The remaining parameters on the General and Details tabs are used to enter logon details and describe where to find the file. Because EXAMPLE1 is installed in localuv, you do not have to complete these fields, which are disabled.
  • Click the Outputs tab. The Outputs page appears:


Leave a Reply