Designer Client Guide: Ibm Infosphere Datastage and Qualitystage

IBM InfoSphere DataStage and QualityStage
Version 11 Release 3
Designer Client Guide
IBM
SC19-4272-00
Note
Before using this information and the product that it supports, read the information in “Notices and trademarks” on page
259.
© Copyright IBM Corporation 1997, 2014.

US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract
with IBM Corp.
Contents
Chapter 1. Tutorial: Designing your first Using the performance monitor. . . . . . . 40
job . . . . . . . . . . . . . . . . . 1 Running server jobs and parallel jobs . . . . . 41
Setting up the exercise . . . . . . . . . . .4 The Job Run Options dialog box . . . . . . . 41
Starting the Designer client . . . . . . . . .4 Parameters page . . . . . . . . . . . . 41
Lesson checkpoint . . . . . . . . . . .7 Limits page . . . . . . . . . . . . . 42
Setting up your project . . . . . . . . . . .7 General page . . . . . . . . . . . . . 42
Lesson checkpoint . . . . . . . . . . .8 Creating jobs by using assistants . . . . . . . 42
Creating a new job . . . . . . . . . . . .8
Lesson checkpoint . . . . . . . . . . .9 Chapter 3. Setting up your data
Adding stages and links to your job . . . . . .9 connections . . . . . . . . . . . . 43
Adding stages . . . . . . . . . . . . .9 Creating a data connection object . . . . . . . 43
Adding links . . . . . . . . . . . . . 11 Creating a data connection object manually. . . 43
Renaming stages and links . . . . . . . . 11 Creating a data connection object from a
Lesson checkpoint . . . . . . . . . . . 12 metadata import. . . . . . . . . . . . 45
Configuring your job . . . . . . . . . . . 12 Creating a data connection object from a stage. . 46
Configuring the data source stage . . . . . . 12 Using a data connection object . . . . . . . . 47
Configuring the Transformer stage. . . . . . 14 Using a data connection object with a stage . . 48
Configuring the target file stage . . . . . . 16 Using a Data Connection object for a metadata
Lesson checkpoint . . . . . . . . . . . 17 import . . . . . . . . . . . . . . . 49
Compiling your job. . . . . . . . . . . . 17
Lesson checkpoint . . . . . . . . . . . 17 Chapter 4. Defining your data . . . . . 51
Running your job and viewing results . . . . . 17 Table definition window . . . . . . . . . . 51
Running the job . . . . . . . . . . . . 17 General page . . . . . . . . . . . . . 51
Viewing results . . . . . . . . . . . . 19 Columns page . . . . . . . . . . . . 52
Lesson checkpoint . . . . . . . . . . . 20 Format page . . . . . . . . . . . . . 53
NLS page . . . . . . . . . . . . . . 54
Chapter 2. Sketching your job designs 21 Relationships page . . . . . . . . . . . 54
Getting started with jobs . . . . . . . . . . 21 Parallel page . . . . . . . . . . . . . 55
Creating a job . . . . . . . . . . . . 21 Layout page . . . . . . . . . . . . . 55
Opening an existing job . . . . . . . . . 22 Locator page . . . . . . . . . . . . . 55
Saving a job . . . . . . . . . . . . . 22 Analytical information page . . . . . . . . 56
Naming a job . . . . . . . . . . . . . 23 Importing a table definition . . . . . . . . . 56
Stages . . . . . . . . . . . . . . . . 23 Using the Data Browser . . . . . . . . . 57
Parallel job stages . . . . . . . . . . . 23 Sharing metadata between projects . . . . . . 58
Server job stages. . . . . . . . . . . . 24 Shared metadata. . . . . . . . . . . . 58
Mainframe job stages . . . . . . . . . . 24 Importing metadata to the shared repository . . 59
Naming stages and shared containers. . . . . 24 Creating a table definition from shared metadata 60
Links . . . . . . . . . . . . . . . . 25 Creating a table from a table definition . . . . 61
Linking parallel stages. . . . . . . . . . 25 Creating a table from a table definition . . . . 62
Linking server stages . . . . . . . . . . 26 Synchronizing metadata . . . . . . . . . 64
Linking mainframe stages . . . . . . . . 28 Managing shared metadata . . . . . . . . 65
Link ordering. . . . . . . . . . . . . 28 Manually entering a table definition . . . . . . 66
Naming links . . . . . . . . . . . . . 29 Creating a table definition . . . . . . . . 66
Developing the job design . . . . . . . . . 29 Viewing or modifying a table definition . . . . . 82
Adding stages . . . . . . . . . . . . 29 Editing column definitions . . . . . . . . 82
Moving stages . . . . . . . . . . . . 30 Deleting column definitions . . . . . . . . 82
Renaming stages. . . . . . . . . . . . 30 Finding column definitions . . . . . . . . 82
Deleting stages . . . . . . . . . . . . 30 Propagating values . . . . . . . . . . . 83
Linking stages . . . . . . . . . . . . 31 Stored procedure definitions . . . . . . . . . 83
Moving links . . . . . . . . . . . . . 31 Importing a stored procedure definition . . . . 83
Editing stages . . . . . . . . . . . . 32 The table definition dialog box for stored
Cutting or copying and pasting stages . . . . 37 procedures . . . . . . . . . . . . . 84
Pre-configured stages . . . . . . . . . . 37 Manually entering a stored procedure definition 85
Annotations . . . . . . . . . . . . . 38 Viewing or modifying a stored procedure
Using the Data Browser . . . . . . . . . 39 definition . . . . . . . . . . . . . . 87
© Copyright IBM Corp. 1997, 2014 iii

Designer Client Guide: Ibm Infosphere Datastage and Qualitystage

Uploaded by

Copyright:

Available Formats

Designer Client Guide: Ibm Infosphere Datastage and Qualitystage

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Designer Client Guide: Ibm Infosphere Datastage and Qualitystage

Uploaded by

Copyright:

Available Formats

IBM InfoSphere DataStage and QualityStage

Designer Client Guide

© Copyright IBM Corporation 1997, 2014.

© Copyright IBM Corp. 1997, 2014 iii

You might also like