Classified Details

Professional Traning On Datawarehousing - Etl Testing

  • Classified Details :

    Duration: 40 Hours Prerequisites Basic knowledge of Software Testing. Course Content 1. Module - I (Database/SQL) Database Overview DBMS, RDBMS, ORDBMS Why Database Required SQL Overview DDL, DML, DCL, TCL Data types SELECT Statement Restricting and Sorting Data Aggregating Data using Group Functions Creating and managing Tables Manipulating Data Sub queries Important Functions Joins and different types Views Index Synonym Constraints Set Operator 2. Module - II (UNIX/LINUX) Overview of UNIX Operating System Basic commands and concepts Command Manuals Regular Expressions Input/Output Redirection Piping Filter Details explanation of File Attributes Job Scheduling Archive/Compress File Environment variables Basic of Editor : vi, sed Quoting and Escape Mechanism Types of Variables Operator Shell Arithmatic How to to write, execute and debug Shell Script Program 3. Module - III (Datawarehousing Concepts) What is Datawarehouse ? Why Datawarehouse require ? DWH Architecture DWH Characteristics Data Mart and types DM vs DWH Common Datawarehouse tasks Data cleansing Partitioning Staging area Metadata OLTP, OLAP, ROLAP, MOLAP Surrogate Key Dimension Modeling Facts and Dimensions DWH Schema designing Advantages of Datawarehouse Star Schema, Snow-flake Schema, Galaxy Schema OBIEE/BI Overview Overview of Reports 4. Module - IV (ETL Concepts) Types of Source Files Data Extraction Different types of Transformations Data Loading Slowly Changing Dimension SCD (Type-1, Type-2 and Type-3) Introduction of ETL Tool Overview of ETL Tool Architecture ETL Tool Environment 5. Module - V (Informatica Power Center Tool) How developers work on Power Center Different components of Power Center and uses Tasks developed in different components Mapping, Session, Worklet, Workflow, Mapplet

    Posted On :
    March 03, 2017

    City :
    Pune

    Category :
    Education

    Sub Category :
    Professional Courses

  • Advertiser Details

    Company Name : 3ritechnologies
    Contact Name : ritesh sharma
    Location : Pune, India
    Mobile / Phone No: 9028250057
    Website Url : www.3ritechnologies.com
    Posted Date : March 03, 2017
    Print this Page

  • Send Query to Advertiser

    verification image, type it in the box