DataStage

 

We are providing Datastage Training based on specific needs of the learners especially we will give innovative one to one Classes which has great opportunities in the present IT market.

Pre- Requisites

    • Preliminary IT knowledge
    • Understanding of elementary configuration issues in relational databases and have expertise in at least one of them
  • COURSE CONTENT
  • Introduction to Data Warehousing

      • What is Data Warehousing .Who needs Data Warehousing?
      • Why Data Warehouse is required?
      • Data Warehousing Architecture
      • Types of Systems
      • OLTP
      • OLAP
      • Data Warehousing Life Cycle
      • ODS
      • Data Marts
      • Types of Data Marts
      • Staging Area

    Data Modelling Concepts

      • Data Modelling Types
      • Source
      • Integration Layer
      • Target

    Multi-Dimensional Data Modelling Concepts

      • What is dimension data modelling?
      • Difference between ER modelling and dimension modelling
      • What is a Dimension?
      • Different Types of Dimension
      • Confirmed Dimensions
      • Junk Dimensions
      • Degenerate Dimensions
      • Slowly Changing Dimensions Types
      • What is a Fact ?
      • Fact Types ,Classification of Facts?
      • Fact less Fact Table
      • Different Schema Types
      • Start Schema
      • Snow Flake Schema
      • Difference between Star and snow flake schema

    IBM DataStage Tool:

    IBM DataStage Contents

      • Introduction about Data Stage
      • DataStage architecture
      • Difference between Server Jobs and Parallel Jobs
      • Difference between Pipeline Parallelism and Partition Parallelism
      • Partition techniques
      • Configuration File
      • Difference between SMP/MPP Architecture
      • Data stage Client Components
      • Data stage Server Components

    DataStage Administrator

      • Introduction about Administrator
      • Project creation and project properties setup

    DataStage Designer

      • Introduction about Designer
      • Repository
      • Palette
      • Type of Links

    File Stages

      • Sequential file
      • Dataset file
      • File set
      • Lookup file set
      • Difference between Sequential file/Dataset/File set

    Database Stages

      • Dynamic RDBMS
      • Oracle Connector
      • ODBC Enterprise

    Processing Stages

      • Aggregate Stage
      • Transformer Stage
      • Surrogate Generator Stage
      • Join Stage
      • Merge Stage
      • Lookup Stage
      • Difference between join/Lookup/Merge
      • Difference between join/Lookup
      • Remove Duplicates
      • Switch
      • Pivot
      • Modify
      • Funnel
      • Different types of sorting and sort stage.
      • Different types of combining and collecting techniques.
      • Filter
      • External filter
      • Difference between filter, External filter and switch stages.
      • Change Capture stage
      • Slowly Changing Dimension stage
      • Job Parameters & Parameter set
      • Run time column propagation
      • Sequencer Jobs

    Debugging Stage

      • Head
      • Tail
      • Pea
      • Row Generator
      • Column Generator
      • Sample

    DataStage Director

      • Introduction to Data stage Director
      • Job Status View
      • View logs
      • Scheduling