IBM Certified DataStage Solution Developer(000-415) : Free Informatica Tutorials

DW-BI Comparisons & Surveys

Bored ? Watch this game to refresh

DataStage OSH Script

The IBM InfoSphere DataStage and QualityStage Designer client creates IBM
InfoSphere DataStage jobs that are compiled into parallel job flows, and reusable
components that execute on the parallel Information Server engine. It allows you
to use familiar graphical point-and-click techniques to develop job flows for
extracting, cleansing, transforming, integrating, and loading data into target files,
target systems, or packaged applications.

The Designer generates all the code. It generates the OSH (Orchestrate SHell
Script) and C++ code for any Transformer stages used.
Briefly, the Designer performs the following tasks:
_ Validates link requirements, mandatory stage options, transformer logic, etc.
_ Generates OSH representation of data flows and stages (representations of
framework “operators”).
_ Generates transform code for each Transformer stage which is then compiled
into C++ and then to corresponding native operators.
_ Reusable BuildOp stages can be compiled using the Designer GUI or from
the command line.
Here is a brief primer on the OSH:
_ Comment blocks introduce each operator, the order of which is determined by
the order stages were added to the canvas.
_ OSH uses the familiar syntax of the UNIX shell. such as Operator name,
schema, operator options (“-name value” format), input (indicated by n<
where n is the input#), and output (indicated by the n> where n is the
output #).
_ For every operator, input and/or output data sets are numbered sequentially
starting from zero.
_ Virtual data sets (in memory native representation of data links) are
generated to connect operators.

Framework (Information Server Engine) terms and DataStage terms have
equivalency. The GUI frequently uses terms from both paradigms. Runtime
messages use framework terminology because the framework engine is where
execution occurs. The following list shows the equivalency between framework
and DataStage terms:
_ Schema corresponds to table definition
_ Property corresponds to format
_ Type corresponds to SQL type and length
_ Virtual data set corresponds to link
_ Record/field corresponds to row/column
_ Operator corresponds to stage

Note: The actual execution order of operators is dictated by input/output
designators, and not by their placement on the diagram. The data sets
connect the OSH operators. These are “virtual data sets”, that is, in memory
data flows. Link names are used in data set names — it is therefore good
practice to give the links meaningful names.

Related Posts Plugin for WordPress, Blogger...

  © Free Blogger Templates Nightingale by Ourblogtemplates.com 2008

Back to TOP  

Follow TutorialBlogs
Home
Add Blog to Technorati