Data Warehousing Training In Chennai

No image available

Sponsored Ads

Price: Free

Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms t...

  • Category: Professional & Short Term Course
  • Published: 12/06/2014
  • Current Rating: /5 0 Vote

    Description

    Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind.


    DataWarehousing concepts:



    • DBMS and RDBMS

    • What is DataWareHousing and necessity of it?

    • Data warehousing architecture

    • OLAP,ROLAP, MOLAP

    • Data mining

    • Meta data

    • Tables, views

    • Constraints

    • Fact and Dimensional Tables

    • Partitioning of tables

    • Concepts of Referential Integrity

    • Concepts of Modelling

    • Database Schema

    • Concepts of normalization

    • Concepts of Slowly Changing Dimensions

    • Concepts of Data Mart

    • Full and Incremental extraction Process

    • Change Data capture


    SQL Concepts:



    • DDL, DML commands

    • All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions)

    • Joins

    • Practice SQLs for some sample test scenarios


    ETL testing:



    • What is ETL and importance of ETL testing??

    • Creating, running and analysing sessions/workflows in Informatica

    • Preparation of Test strategy, Test plan and estimations

    • Testing scenarios, creation of test cases and scripts

    • Test case execution and defect tracking and reporting


    Report Testing:



    • Validation of the report data with DB and UI testing

    • Preparation of Test data


    Levels of testing



    • Unit testing

    • Intigration testing

    • Module testing

    • System testing

    • Uat


    Practice sessions on E


    Informatica Training in Chennai | Best Informatica Training in Chennai |


    informatica training in Chennai Adyar | informatica Training with Placement in


    Chennai| Informatica Training with Placement in Chennai Adyar | Data warehousing Online


    Training in Chennai Adyar


    Venue:


    Kamatchi Krupa Apts,
    No: 84/8, Ground Floor,
    Venkatarathinam main street,
    Venkatarathinam Nagar,
    LB Road, Adyar, Chennai,
    Tamil Nadu - 600020.


    Selvakumar (99520 10141)


    Related Ads

    Leave your comment


    Copyright © 2016 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us: query[at]tuffclassified.com