Datastage free tutorial

Datastage Free Tutorial

Introduction to Datastage DataStage Overview It is an Comprehensive ETL Tool, Which provides, end to end ERP Solutions Some of the Most popular ETL Tools are: DSPX àleader of ETL Tools, Started from 2006 Informatics ODI SAS (ETL STUDIO) BODI ABNITRO History of DataStage Has more than 12 years of History 1st release was in 1997 1997 – VMARK – UK - - > Mr. LEE SCHEFFLER - - > Father of Data stage - - >Data Stage was called as Data Integrator during 1997 - - > Torrent (Data Integrator)

Architecture of Datastage Repository :- / Work Area / Project It is a work Area with collection of different Components.

Different Repository Components are •Table Definition •Shared Contains •Routines ..etc •Jobs It is an Environment for developing ETL jobs using the components.

Engine :- /Data stage Server •Responsible for Executing Data stage jobs.

•Engine is also Responsible for partitioning, Re- partitioning and Reverse partitioning.

Administrator in Datastage Administrator For a Specific project Project Add create protected project Ok In, if we don’t have web console, In 8 we have wed console, and same permissions are given here Add check points.

Tracing Reporting the activities that are requested by the client at server .

How can you delete logs in Repository ?

Sol :- Auto purge of Job logs.

RCP:- Job properties :- Entire RCP •Enable Runtime column propagation Violating Mapping constraints According to Requirements

Director in Data Stage Director 1.Schedule 2.Views 3.unclock job 4.monitor 5.batch jobs 6.message handling Tool Run Director Job Report - / DTD DTD – design Turnover Document File Generate report click the link Generates the report parallel job opens

report for

Oracle Enterprise in Data Stage Oracle Enterprise Table name = dim 1 Write method = upset Upset order = update then insert Compile and RUN In SQL plus, Select * from dim 1; Skip 1 2 3

S no 111 222 333

S name shilpa Renuka Archama

Joins in Datastage Join Join needs Same key Column Name When we join 2 tables For ex:-EMP and Dept In join, While mapping If Join type = Inner/left outer join, then Dept no while joining comes from left

And Also Issues Interview Questions How to’s For More Datastage Free Tutorials Please Visit: http://bit.ly/1tt9Rk9