Learning DataStage

Ranked #5,782 in Computers & Electronics, #109,208 overall

Learning DataStage

I have never stopped learning new things about DataStage.  This Lens is for people like me who want to keep improving their knowledge and skills with this product.

Getting Stage Property and Options Help

You can get immediate help on almost any stage property of option via the DataStage Designer help files.

Inside a stage properties form click on help or press F1. Find the bitmap of the stage and click on the Properties tab on the bitmap to go to the properties help page. There you should find short help on almost every property and option of that stage.

Learning how to use Stages

Tips and help on specific DataStage stages.

DataStage Developer Shortcuts
Handy buttons, thinks you might have missed, Sequence job shortcuts.
Parallel Job lookup types
Big lookups and small lookups in parallel jobs.
Parallel job transformer performance tips
Some call it slow, some call it evil, should the parallel transformer be used?
How to do sorting in Parallel jobs
Sorting and partitioning is the single most important part of high volume parallel processing.
17 Mistakes that ETL Designers make with Very Large Data
These are the mistakes that ETL designers can make when processing scary high data volumes.
DataStage and QualityStage 8 Product News from IOD 2007
The product roadmap news for DataStage and QualityStage version 8.1 due Q1 of 2008.

Use Annotations!

Annotations are a great way to document your ETL job within the job and help future developers understand what you did.

In this example the green annotation is a "Description Annotation" that shows the contents of the job description field. There can be just one of these for each job.

Photobucket - Video and Image Hosting

by

vmcburney

Vincent McBurney has been using DataStage for several years and via his blog, his magazine articles and his wiki entries he tries to spread the DataSt... more »

Feeling creative? Create a Lens!