Price: Check with seller



Best Institute for Datastage Training in Chennai provided by Real time working Experts. Datastage Training, ETL Tool Training, Data Modeling Training, Analytic SQL Training with real-world ETL process implementations organized in Datastage training classes. 
Greens Technology in Adyar is the Best Datastage training institute in Chennai offers Hands-On Datastage courses in Chennai with Job Placement by ETL professionals having Datastage projects experience using ETL and Business Intelligence for more than 10 years. All our sessions are completely practical and interactive paired with Realtime Methodologies, Project Scenarios and Case studies exclusively on Datastage.


Introduction to Data warehousing

  • What is Data warehousing

  • Architecture of Data warehousing

  • Definitions

  • ETL Process

  • Types of Tables in D/W

  • Types of FACTS tables

  • Types of DIMENSION tables

  • Types of Schemas in D/W

  • What is Data Mart

  • Warehouse Approaches


Data Modelling

  • Introduction to Data Modelling

  • Entity Relationship model (E-R model)

  • Data Modeling for Data Warehouse

  • Dimensions and fact tables

  • Star Schema and Snowflake Schemas

  • Coverage Tables

  • Fact less Tables

  • What to look for in modelling tools

  • Modelling tools


ETL Design process

  • Introduction to Extraction, Transformation & Loading

  • Types of ETL Tools

  • What to look for in ETL Tools

  • Key tools in the market

  • ETL Trends & New Solution Options


Data stage installation

  • Datastage Installation

  • Prerequisites to install Datastage

  • Installation process



Introduction to Datastage version 8.x

  • Datastage Introduction

  • IBM Information Server architecture

  • DataStage within the IBM Information Server architecture

  • Datastage components

  • DataStage main functions

  • Client components


Datastage Administrator:

  • Datastage project Administration

  • Editing projects and Adding projects

  • Deleting projects

  • Cleansing up project files

  • Auto purging

  • Permissions to users

  • Runtime Column Propagation

  • Enable Remote Execution of Parallel jobs

  • Add checkpoints for sequencer

  • Project protect

  • .APT Config file


Datastage Designer:

  • Introduction to Datastage Designer

  • Importing table definitions

  • Importing flat file definitions

  • Managing the meta data environment

  • Dataset management

  • Deletion of Dataset

  • Importing jobs

  • Exporting jobs(Back up)

  • Configuration file view

  • Explanation of Menu Bar

  • Palette

  • Passive stages

  • Active stages

  • Database stages

  • Debug stages

  • File stages

  • Processing stages

  • Mutiple Instances

  • Runtime Column Propagation(RCP)

  • Job design overview

  • Designer work area

  • Annotations

  • Creating jobs,deleting jobs

  • Compiling jobs

  • Batch compiling

  • Aggregator stage ,Copy stage

  • Change Capture stage,Compress stage

  • Filter stage,Funnel stage

  • Modify stage

  • Join stage,Lookup stages

  • Difference between join and Lookup stages

  • Merge stage

  • Difference between Lookup and Merge stages

  • Remove duplicate stage

  • Sort stage,Pivot stage

  • Surrogate key stage, switch stage

  • Types of Lookups

  • Types of Transformer stages

  • Basic transformer stage

  • Transformer stage

  • Null handling in Transformer stage

  • If Then Else in Transformer

  • Stage variables

  • Constraints

  • Derivations

  • Peek stage, Head stage, Tail stage

  • Job properties

  • Local variables

  • Functions in Transformers

  • String,Date,Null handling functions

  • All properties in all stages

  • Slowly changing Dimensions (SCD)

  • SCD Type-1

  • SCD Type-2

  • SCD Type-3

  • Implementation of SCD T ype-1 in Datastage

  • Implementation of SCD T ype-2 in Datastage


Datastage Director:

  • Introduction to Datastage director

  • Datastage Director window

  • Jobs status view

  • Datastage director options

  • Running Datastage jobs

  • Validating a job

  • Running a job

  • Batch Running

  • Stopping a job and resetting job

  • Monitoring a job

  • Job scheduling

  • Unscheduling a job

  • Rescheduling a job

  • Deleting a job

  • Unlocking jobs

  • View Logfile

  • Clear log

  • Fatal error description

  • Warning description

  • Info description

  • Difference between Compile and Validate

  • Difference between Validate and Run


More Details

Total Views:5
Reference Id:#472047
Phone Number:8939915577
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved | |   24x7 support |   Email us : info[at]