Welcome to Wings Academy

DATASTAGE

DATASTAGE

Datastage Training in Mumbai

Learn at Home with Wings Academy

Classroom and Online Courses by Certified Experts

Our Classroom and Online Training Program insist you to become a specialist at Advanced Industrial Technologies in a Month. Hands-on Learning with Project sessions. We are "One of the Best Classroom and Online Training Course Provider" in India with Placement Support.

About Datastage Training Course in Mumbai

Datastage is an ETL tool which extracts data, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. Start Learning with us Wings Academyh Datastage Classroom and Online Training Course.

Syllabus of DataStage Course in Mumbai

 Introduction to Data Warehouse Concepts

  • What is Data Warehouse?
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture
  • What is Data Modelling?
  • Explorer on Dimensional Modelling
  • Explorer on Star Schema
  • Explain Snowflake Schema
  • Understanding on Dimension
  • Understanding on Fact
  • Slowly Changing Dimension
  • Lifecycle of Data Warehous

 Understanding onETL  (EXTRACTION, TRANSACTION, LOAD)

  • Overview of ETL
  • Feature and benefit for Business
  • Different SCD Types
  • ETL tools in markets
  • Explain on staging tables
  • Explain on Transformation
  • Loading data into different stage of table

 Overview of InfoSphere DataStage

  • What is InfoSphere DataStage?
  • Architecture of DataStage
  • Explain on Topologies
  • Components in DataStage
  • Runtime Architecture
  • OSH Script and Execution Flow

 Install and Configuration on InfoSphere DataStage

  • Prerequisite for InfoSphere DataStage
  • Install InfoSphere DataStage
  • Verify Installation
  • Setup Environment variables
  • Create / Update / Delete projects
  • User creation and Grand permission

Working with DataStage Designer

  • Overview of Designer
  • Explorer on DataStage Designer
  • High level overview of Commonly used Stages
  • Schema
  • Pipeline Parallelism
  • Manipulate configuration file
  • Repository Palette
  • Passive and Active stages
  • Annotation and Create jobs
  • Import and Export Metadata
  • Dataset Management
  • Partition technique

 DataStage Job

  • Overview of Job types
  • Explain on Sequence and Parallel Jobs
  • Explain on Server Jobs
  • Different stages
  • Understanding Containers

 DataStage Director

  • Introduction to DataStage Director
  • User Interface Director
  • Job status and view
  • Compiling Single and Multiple jobs
  • Run, Reset ad Restart jobs
  • Scheduling Batches
  • Performance monitor

 Creating Parallel Job

  • Overview of Parallel Jobs
  • Design a Parallel Job using Designer
  • Pipeline Parallelism
  • Partition Parallelism
  • NLS Mode Work
  • Maps in Parallel Jobs
  • Run Parallel Jobs

Handle Files

  • Introduction to file handling
  • Sequence and Complex file stage
  • Huge File Manipulation
  • Error and Invalid Records Rejection

 File Stages

  • File Stages
  • Sequential File stage
  • Explain on DataSet
  • Complex Flat File stage
  • Create jobs to read and write on sequential files
  • Multiple file reader using file patterns
  • Null handling in File Stage
  • Lookup file Set

Combining and Partitioning Data

  • Overview of data process for combine and Partitioning
  • Combine data using by Lookup stage
  • Combine data using by merge stage
  • Combine data using by Join stage
  • Combine data using the Funnel stage

Sorting and Aggregating Data

  • Sort data using in-stage sorts and Sort stage
  • Data Segregation using Aggregates stage
  • Unique data using Duplicates stage

 Transformation on Data

  • Understanding DataStage internal logical message
  • Column generator and Row generator
  • Transform message one to another format
  • Filter Data using on business criteria
  • Control data flow based on data conditions
  • Cover real time scenario using different Processing Stages
  • Routes creation

Working with Relational DataBase

  • Understanding Database Stage
  • Database Metadata
  • Explain on ODBC Connection
  • Import Definitions for Tables.
  • Use Connector stages in a job.
  • Define SQL statements using Builder
  • ODBC Connector
  • Oracle Connector
  • Parallel Job with Connector

Advanced Parallel Jobs

  • Overview of Type1 and Type2 process
  • Range look process
  • Job Performance analysis
  • Performance tuning

Job Sequence

  • Job activities in Sequencer
  • Sequence Trigger
  • Notification and Terminator activity
  • Start and End Loop activity
  • Error and Exception handling activity

Working with Cleansing Data

  • Overview of Cleansing
  • Explain Workflow of Standardization
  • Create and Configure Standardize Stage Job
  • Explain on Rule sets
  • Managing Rule sets

 Exception Handling on DataStage

  • Introduction to Exception Handling
  • How to Design job to link with Exception
  • Explain on Exception stage
  • One-source and Two-source Match Exception Stage
  • Route exception to Exception Stage

 Deployment on InfoSphere DataStage

  • Introduction to InfoSphere Information Server Manager
  • Explain on Deployment life cycle
  • Adding Domain on Information Server Manager
  • View job and asset properties
  • Explain Deployment Package
  • Deployment Workflow
  • Define Deployment Package
  • Setup Deploy Path
  • Deploy Package
  • Import and Export Assets
  • Explain various types of Source Control for DataStage

 Working with Monitoring Jobs

  • Introduction to Monitoring Jobs
  • Explain on Operations Console
  • How to Monitoring Jobs by using console

 Performance Tuning Job

  • Understanding performance impact activities
  • Design Job for Optimal Performance
  • Design flow with minimize CPU and Memory usage
  • Explain on Buffering
  • Deadlock prevention

 Best Practice on DataStage and Data Load

About Experienced Datastage Trainer

  • Our Datastage Training in Mumbai. Trainers are certified professionals with 7+ years of experience in their respective domain as well as they are currently working with Top MNCs.
  • As all Trainers are Datastage domain working professionals so they are having many live projects, trainers will use these projects during training sessions.
  • All our Trainers are working with companies such as Cognizant, Dell, Infosys, IBM, L&T InfoTech, TCS, HCL Technologies, etc.
  • Trainers are also help candidates to get placed in their respective company by Employee Referral / Internal Hiring process.
  • Our trainers are industry-experts and subject specialists who have mastered on running applications providing Best Datastage training to the students.