Welcome To Eazygurus

Datastage

Course Name        :   Data Warehousing -DATASTAGE Online Training
Duration                 :  35 hrs

STUDENTS ENROLLED

    • Data Warehousing Concepts            
      • Data Warehousing Architecture
      • ETL Project Phases
      • ETL Process
      • ETL Architecture
      • Over view of Project Architecture
      • Data Modeling
      • Data Warehousing Teams and Roles
      • Understand Mapping Document
    • Datastage Introduction
      • History and Features
      • Difference between 7.5X2 & 8.x
      • IBM DS 8.0.1
      • DS InfoSphere 8.5 Enhancements
      • IBM DataStage 7.5X2 $ 8.x Architecture
      • Partition & Pipeline Parallelism
      • Partitioning & Re- Partitioning Techniques
      • Configuration File & Node Components
    • IBM Web Sphere DS & QS
      • 5X2 & 8.x Enhancements – New Features
      • Parallel Processing Environments (SMP,MPP etc.,)
      • DS Client Components Overview
      • DS Architecture Components Overview
    • Datastage Designer
      • DS Job Design Process
      • Compile, Force Compile and Multiple Job Compile
      • Import & Export of Repository Components
      • Node Configuration
    • Datastage Director
      • Schedule / Run / Validate a Compiled Job
      • Message Handling
      • Monitor Jobs, Filter / Purge Logs
      • Unlocking Job & Customize
    • Datastage Jobs & Stages
      • Difference 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
    • Working with File Stages
      • Sequential File Stage
      • Data Set and Types
      • File Set
      • Differences – Data Set , File Set, Sequential File Stages
      • Lookup File Set Stage
    • Development & Debug Stages
      • Row Generator and Column Generator Stage
      • Head, Tail and Sample Stages
      • Peek Stage
      • Copy Stage
    • Working with Relational Databases            
      • Enterprise and Plug-in Stages Overview
      • Oracle, DB2, SQL Server Stages
      • ODBC
      • Dynamic RDBMS Stage

    Processing Stages:

    • Horizontal Combining            
      • Join Stage
      • Lookup Stage (Normal, Sparse, Range, Case less)
      • Merge Stage
      • Differences between Lookup, Join & Merge
      • Funnel Stage
    • Sorting and Vertical Combining
      • In-stage sorts
      • Sort Stage
      • Aggregator Stage
      • Remove Duplicates Stage
    • Data Transformation with Transformer
      • Basic Transformer
      • Parallel Transformer
      • External Functions
      • Stage Variables and System Variables
      • Transformer Constraints
      • Transformer Execution Order
      • External Before / After Routines
    • Filtering Methods
      • Constraints & Source Level
      • Filter Stage
      • Switch Stage
      • External Filter Stage
    • Remaining Stages
      • Modify Stage
      • Compress & Expand Stage
      • Decode & Encode Stage
      • Generic Stage
      • Pivot Stage
    • Slowly Changing Dimensions
      • Type – 0, 1, 2, 3, 4 & 6 Dimensions
      • Implementing SCD – I & II
      • SCD Stage
      • Change Capture & Change Apply Stage
      • Difference & Compare Stage
      • Surrogate Key Stage
    • Restructure & Real Time Stages
      • Column Export, Column Import Stages
      • XML Input & XML Our Put Stage
    • Performance Tuning Techniques
      • Performance Tuning with best practices
      • Performance Tuning with Partitioning Techniques
      • Job Score
      • Performance Analysis & Estimate resource
    • Advanced Topics                        
      • Parameter Set
    • Job Control
      • Job Sequencing
      • Batch Jobs

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.