mindquest-technologies
The training for the software engineers and the academic students is given by Industry certified Professionals, having 5 - 8 yrs of Experience. Students We adhere to quality education by continues feedback system, personal attention towards the students
Courses
DATASTAGE
HYPERION
TERADATA
JAVA
SAS
.NET
PHP
MULTI MEDIA
Training Enquiry Form
LIVE PROJECTS
Up Date News

Live projects for Btec , MCA  & Msc;

 
 

 DataStage 8.1

  UNIT 1
   
 

Data Warehousing Concepts

  • About Data Warehouse& Data Warehousing
  • Active Warehouse & Passive Warehousing
  • Data Warehouse Usages Evolution
  • OLTP, DSS, OLAP & OLCP
  • SDLC(DWD life cycle)
  • Schema Types(star, Snow etc...)
  • Characteristics of Dimensions & Fact Tables
  • ETL Process & Cleansing (parsing,Correcting,Standadize,Matching and Consolidate)
  • ER & Dimensional Model Overview
   
   UNIT 2
   
 

Introduction To Datastage

  • History and Features
  • About Ascential suite
  • Traditional Batch Processing
  • Partition & Pipeline parallelism
  • Partitioning & Re-Partitioning Techniques
  • Combinality, Combining & Collecting Techniques
  • IBM Web Sphere DataStage 8 Architecture
  • Configuration File & Node Components
   
   UNIT 3
   
 

About DataStage 8.1

  • Differences between 7.5X2 & 8.1 
  • Parallel Processing environments (SMP,MPP etc..)
  • Topologies ( Two tier, Three tier etc..)
  • Information Analyzer Overview
  • DataStage & DataStage Quality stage overview
  • Web Console for Information Server
   
   UNIT 4
   
 

DataStage Jobs & Stages

  • Differnce between server & parallel jobs
  • Overview of Parallel jobs , Server jobs, Mainframe jobs, migration jobs and job sequencing jobs
  • Repository, DS Designer toolbar & Palette
  • Active and Passive stages
  • palette Customization
  • About link Makers
  • Frame Work Operators
   UNIT 5
   
 

Working with file stages

  • Sequential file & stage rules
  • Data set & Format 
  •  Fileset & lookup fileset
  • differences between Dataset, fileset & seq file
  • Complex flat file
   UNIT 6
   
 

Development / Debug stages and Stub Stages 

  • Row and Column Generator
  • Head, Tail and Sample
  • Peek
  • Write Range map
  • Copy stage

 

   UNIT 7
   
 

Working with relational Stages

  • Enterprise and Plug-in Stages
  • Oracle ,SQl Server
  • TERADATA ( Fast load, Multi Load & TPump )
  • ODBC & ODBC Connector 
  • Dynamic RDBMS
   UNIT 8
   
 

DataStage 8 New features

  • Data Connections
  • Parameter  set
  • SQL Builder
  • Quick Find & Advanced find 
  • Performance Analysis
  • Resource Analysis
  • Import and Export
   UNIT 9
   
 

Processing Stages

Sorting

  • In stage sort & Stage sort ( Key Change & Cluster ) 

Combining ( Horizontal & Vertical ) & Funnelling

  • Join, Lookup( Normal, Sparse, Range & case less ) and Merge
  • 15 differences between Join, Lookup and Merge
  • Aggregator stage
  • Remove Duplicate Stage
  • Funnel Stage

Filtering Methods

  • Filter stage, Switch Stage & External Filter stage
  • Constraints 

Data Transformation with Transformer & Modify stage

  • Basic transfomer Vs Transformer
  • External Functioins & Macros
  • Stage Variables & System Variables
  • Execution Order
  • External Before and After Sub Routines
  • Modify Stage

SCD Implementations & Surrogate Key Generation

  • SCD Type-1, Type-2 implementation in 7.5X2
  • Change Capture and Change Apply Stages
  • SCD Type-1, Type-2 Implementation in 8.0.1
  • SCD Stage
  • Surrogate Key Stage

 Other Stages

  • FTP stage
  • Pivot stage
  • Compress & Expand
  • Encode & decode Stage
  • Generic Stage 

Real Time & Restructing Stages

  • XML Input & XML output stage
  • Column Export and Column Import Stage 

 

   UNIT 10
   
 

Quality Stages 

  • Parsing, Correcting, Standardise, matching & Consolidate
  • Investigate Stage
  • Standardize Stage
  • Match Frequency Stage
  • Unduplicate Match stage
  • Reference Match
  • Survive Stage
  • WAVES 
  • MNS
   UNIT 11
   
 

Performance Tuning tips

  • Important Environment Variables
  • Partitioning Techniques 
  • Techniques for Job Development
  • Monitor
  • Job Score
  • Containers
   UNIT12
   
 

 Job Control & Job Sequencing

  • Introduction to JCL Scripting
  • Job Sequencing ( Run Stages, Error Handling, Flow Control Stages )
  • Batch Jobs
   UNIT 13
   
 

DataStage Director

  • Message Handling  ( Job Level and Project Level )
  •  Schedule / Validate / Run
  • Views
  • Unlocking and Customize
   UNIT 14
   
 

 Web Console for IBM Information Server

  • Security Services 
  • Session Services
  • logging Services
  • Scheduling Services
  • Domain Management
  • Reporting Services 
   UNIT 15
   
 

DataStage Adminstrator

  • ADD, Delete Projects
  • Run time Column Propagation
  • Adding Entirs and the Tools Menu
  • Setting job parameter Default
  • Tracing Server activity
  • DataStage Engine Commands
   UNIT 16
   
 

Information Analyzer

  • Analyzer Configuration
  • Column Analysis 
  • Primary Key Analysis 
  • Foreign Key Analysis 
  • Cross domain Analysis 
  • Base line Analysis 
   UNIT17
   
 

Project Overview

  • Data Warehouse Development Life Cycle
  • ETL Activities, Role & Responsibilities
  • Understanding Mapping Document
  • Namming Conventions 
   
   
 

 

   
   
 

 

   
   
 

 

   
   
 

 

 

Training Enquiry Form
Home|Careers |Privacy Policy | Terms& Conditions |Disclaimer| Accessibility|Contact Us
2005-2009 all rights reserved Mind Quest Technologies