Welcome To Eazygurus

Data Warehousing – ERWIN

Course Name        :   Data Warehousing – ERWIN Online Training
Duration                 :  20 hrs

STUDENTS ENROLLED

    • What is data base?
    • What is data warehouse?
    • What is Data Warehousing?
    • Why DWH? Why DB?
    • What is OLTP?
    • What is OLAP?
      1. ROLAP
      2. MOLAP
    • HOLAP
    • Different usages of DWH in different areas.
    • What is Data Marts?
    • Differences among data marts, databases and DWH
    • Characteristics for DWH
    • Real time cases and usage
    • Emerging Trends in DWH

    Data Warehousing

    • How to build/design DWH?
    • Subject Areas, Data Marts
    • Data Mining?
    • Data Modeling – Different models in building DWH.
      1. Start Schema
      2. Snowflake Schema
    • Hybrid Schema
    1. Why Star Schema? Snowflake Schema? Hybrid Schema?
    • Different phases in building a DWH.
      1. Source àStagingàTransform/UniformàTarget (DWH)
      2. Source (OLTP)
        • Different types of sources
        • Flat Files
        • Databases
        • Others
    • Staging (Critical part of ETL)
    • What and Why staging?
    • Purpose of staging?
    • Types of stages (Flat files, DB…)
      1. Transform/Uniform (Critical Part of ETL)
    • Necessity of transformation
    • Standardization/uniform/integration data before transferring to Target
      1. Target (DWH)
        • Types of targets (DWH, Files, Cubes…)
        • Usage of target
    • The core parts (tables) of DWH. (The most important topic)
      1. Its all about tables (DWH is nothing but tables, if you think Physically)
      2. Types of tables in DWH
        • Dimension Tables
        • Fact Tables
        • Fact less fact tables
        • Bridge/Intermediate/XRef tables
    • Dimension Tables
      1. What is dimension table?
      2. What do we store in dimension tables?
    • What is Surrogate Key?
    1. Why we need surrogating?
    2. Types of dimension tables
      • Confirmed Dimension
      • Slowly Changing Dimension
        1. Type-1 Dimension Tables
          • What is Type-1 dimension?
          • The structure of Type-1 Dimension table
          • When do we need Type-1 dimensions
          • How to load Type-1 dimension tables
        2. Type-2 Dimension Tables
          1. What is Type-2 dimension?
          2. The structure of Type-2 Dimension table
    • When do we need Type-2 dimensions
    1. How to load Type-2 dimension tables
    2. Different ways of loading Type-2 dimension tables
    1. Type-3 Dimension Tables
      1. What is Type-3 dimension?
      2. The structure of Type-3 Dimension table
    • When do we need Type-3 dimensions
    1. How to load Type-3 dimension tables
    2. Different ways of loading Type-3 dimension tables
    1. Zunk Dimension
    2. De-Generated Dimension
    • Fact Tables
      1. What is fact table?
      2. What do we store in a fact table
    • Structure of a fact table
    1. What is measure/fact? Types of measures
    2. How to load fact tables?
    3. Different ways of loading fact tables in different cases with different types of dimension tables.
    • Types of fact tables loading (incremental)
    • Fact less fact tables
      1. What is fact less fact table?
      2. What do we store in fact less fact tables?
    • Why do we need/purpose of fact less fact tables?
    1. The structure of fact less fact table?
    2. How to load fact less fact tables?
    • Bridge Tables
      1. What is bridge table?
      2. Why do we need or purpose of bridge table?
    • What do we store in bridge tables?
    1. The structure of bridge table?
    2. How to load bridge tables?

    ETL (Extraction, (Staging), Transformation, Loading]

    • Extraction (From Source)
      1. What is extraction?
      2. How to extract different types of tables discussed in DWH section?
    • How to extract from different types of sources? (Flat Files, DBs, Excel and Other)
    1. Different ways of extraction? (incremental)
    2. The run date
    • Staging
      1. What is staging?Staging Area
      2. The necessity of staging.
    • Staging area can be database or files
    1. Maintenance of staging
    2. How to stage data in staging area?
    • Transformation/Uniform/Generalization/ Integration (The logic part)
      1. What is transformation? (The business logic)
      2. How to transform data using Informatica tool?
    • What is uniform/Generalization/ Integration?
    1. Need of uniform/generalization/ Integration
    • Loading (To Target)
      1. What is loading?
      2. How to load different types of tables discussed in DWH section?
    • The order of loading
    1. Different techniques of loading

    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
    • week, 3 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.