Enquiry Now !      

Datastage Training Pune-Technogeeks, Datastage Institute Pune, Datastage Classes Pune

    IBM InfoSphere DataStage   8.5
     
    DURATION OF  TRAINING : 6 WEEKENDS
     

    SYLLABUS

    Data Warehouse Fundamentals

    • An introduction to Data Warehousing
    • purpose of Data Warehouse
    • Data Warehouse Architecture
    • Operational Data Store
    • OLTP Vs Warehouse Applications
    • Data Marts Data marts Vs Data Warehouses
    • Data Warehouse Life cycle 

    Data Modelling

    • ‚ÄčIntroduction to Data Modelling
    • Entity Relationship model (E-R model)
    • Data Modelling for Data Warehouse
    • Dimensions and fact tables
    • Star Schema and Snowflake Schemas
     

    ·         ETL Design Process

    Introduction to Extraction, Transformation & Loading- Types of ETL Tools – Key tools in the market.
     

    ·         Data Stage Installation

    Data stage Installation – Prerequisites to install Data stage – Installation process.
     

    ·         Introduction to DataStage Version 8.5

    DataStage introduction – 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 – Global variable setting – Environment management – Auto purging – Rutime Column Propagation(RCP) – Add checkpoints for sequencer – NLS configuration – Generated OSH (Orchestrate Engine) – System formats like date, timestamp – Project protect – Version details.
     

    ·         DataStage Director

    Introduction to DataStage Director – Validating DataStage Jobs – Executing DataStage jobs – Job execution status – Monitoring a job – Job log view – job scheduling – Creating Batches – Scheduling batches.
     

    ·         DataStage Designer

    Introduction to DataStage Designer – Importance of Parallelism – Pipeline Parallelism – Partition Parallelism – Partitioning and collecting – Partition techniques – DataStage Repository Palette –
    Passive and Active stages – Job design overview – Designer work area – Annotations – Creating jobs – Importing flat file definitions – Dataset Overview
     

    ·         Working with Parallel Job Stages

    Database Stages
    Oracle – Teradata – ODBC – dynamic RDBMS – DB2
    File Stages
    Sequential file – Dataset – File set – Lookup file set.
    Processing Stages
    Copy – Filter – Funnel – Sort Remove duplicate – Aggregator – Modify – Compress – Expand – Decode – Encode – Switch – Pivot stage – Lookup – Join – Merge – difference between look up, join and merge – change capture – Change apply – Compare – Difference – Surrogate key generator – Transformer.
    Debug Stages
    Head – Tail – Peek – Column generator – Row generator.
    Real Time Stages
    XML input – XML output –XML Transformer, Java packs, Webservice packs
    Local and Shared containers
     

    ·         Advanced Stages in Parallel Jobs (Version 8.5)

    Range Look process – Surrogate key generator stage – Slowly changing dimension stage – iway stage – FTP stage – Java plug in – Job performance analysis – Resource estimation – Slowly Changing Dimensions implementation – Performance tuning.
     

    ·         Job Sequencers

    Arrange job activities in Sequencer – Triggers in Sequencer – Restablity – Recoverability – Notification activity – Terminator activity – Wait for file activity – Start Look activity – Execute Command activity – Nested Condition activity – Exception handling activity – User Variable activity – End Loop activity – Adding Checkpoints
     

    ·         Information Analyzer

    IBM WebSphere Information Analyzer overview – Data Profiling process – Column analysis – Primary key analysis – Foreign key analysis – Cross-domain analysis – Baseline analysis – Aanalysis result publication – Deleting statistics reports – Baseline analysis reports – Cross-domain analysis summary statistics reports – Beseline analysis reports – Cross-domain analysis reports – Primary key reports – Foregin key analysis reports.
     

    ·         WebSphere Quality Stage

    About Data Quality – DataStage quality stages – Investigate stage – Standardize stage Match Frequency stage – Unduplicate Match stage – Reference Match Stage – Survive stage.
     

    ·         IBM Information Server Administration Guide

    IBM WebSphere DataStage administration – Opening the IBM Information Server Web console – Creating users in the console – Assigning security roles to users and groups – Managing licenses – Managing active sessions – Managing logs – Managing schedules – Backing up and restoring IBM Information Server.
abc
abc


Enquiry Now !