Demos On 16th / 17th December
PIMPLE SAUDAGAR :    Hadoop BigData (09:00 AM)   |   AWS - Amazon Web Services (11:00 AM)   |   Selenium (11:00 AM)   |   Angular JS (11:00 AM)   |   Informatica (11:00 AM)   |   QTP (2:00 PM)      DECCAN :    Selenium (10:00 AM)   |   AWS - Amazon Web Services (1:00 PM)   |   DevOps (2:00 PM)   |   Manual Testing (2:00 PM)   |   UNIX Shell Scripting (2:00 PM)   |   SAP MM (3:00 PM)      
ISO 9001:2015 Certified Organization  |  Pearson Exam Center

Datawarehousing - ETL Testing

Overview

ETL stands for Extract, Transform and Load. An ETL tool extracts the data from different RDBMS source systems, transforms the data like applying calculations, concatenate, etc. and then load the data to Data Warehouse system. The data is loaded in the DW system in the form of dimension and fact tables.

Objectives :

  • Understanding of complete Software Development Life Cycle and Testing Lifecycle.
  • Get the testing experience on real time projects which helps candidates to understand real Industry processes.
  • Provide Interview tips and conduct mock test.

Duration : 36 Hours

Prerequisites : Knowledge of Manual Testing, Knowledge of DBMS/SQL is advantageous

Training Highlights: We are providing Data Warehousing training at affordable cost. We teach Data Warehousing courses with real time scenarios and give interview guidance. Join us Build your career in Data Warehousing (DWH) as a real time professional. Our main focus is to provide individual training and corporate training in Data Warehouse using ETL Tool Informatica.

Course Syllabus

Datawarehousing - ETL Testing
  1. Database/SQL
    • RDBMS Concepts
    • Data Models
    • Entity Relationship Model
    • Normalization
    • DBMS, RDBMS, ORDBMS
    • SQL Overview
    • Introduction to SQL
    • Data types
    • SELECT Statement
    • Operators
    • Pseudo Column
    • SQL Statements
    • Data Definition Language (DDL)
    • Data Manipulation Language (DML)
    • Transaction Control Language (TCL)
    • Data Control language (DCL)
    • Join
    • Inner/Equi Join
    • Non-Equi/Cross Join
    • Self Join
    • Outer Join
    • Constraints
    • Primary Key Constraint
    • Foreign Key Constraint
    • Unique Key Constraint
    • Not Null Constraint
    • Check Constraint
    • Set Operator
    • Union
    • Union All
    • Intersection
    • Minus
    • Sub Query
    • Sub/Inner Query
    • Correlated Sub Query
    • Object
    • Index
    • Synonym
    • View
    • Built-in Functions
    • Aggregate Functions
    • Character Function
    • String Functions
    • Case Manipulation Functions
    • Date Functions
    • Analytical Functions
  2. Datawarehousing/ETL
    • Datawarehousing Fundamental
    • Datawarehousing Overview
    • DWH Characteristics
    • Types of Datawarehousing
    • Data Mart
    • Database vs Data Warehouse
    • Data Mart vs Data Warehouse
    • Data Warehouse benefits
    • DWH Architecture
    • Datawarehousing Terminologies
    • Data Cleansing, Partitioning
    • Staging area, Metadata
    • OLTP, OLAP, ROLAP, MOLAP
    • Surrogate Key
    • Snapshot, View and Materialized View
    • Meta Data, Data Mining& Data Cube
    • Dimension Modeling
    • Facts and Dimensions
    • Hierarchies and Levels
    • Measures & DWH Schema Schema
    • Additive, Semi Additive, Non Additive Fact/Measure
    • ETL Overview
    • Process Flow of ETL
    • Types of Sources and Target
    • ETL Data Load types
    • Active vs Passive transformation
    • Extraction Methods in ETL
    • Tracing Level
    • Types of Data used for ETL Process


    • Slowly Changing Dimension
    • What is Slowly Changing Dimension?
    • SCD Types : Type-1, Type-2, Type-3
    • ETL Testing Process
    • Categories of ETL Testing
    • ETL Test Scenarios and Test Cases
    • Types of ETL Bugs/Defects
    • Responsibly of ETL Tester
    • OBIEE/BI Overview
    • Introduction to OBIEE
    • Business Intelligence Basics
    • Overview of Reports
    • Slice and Dice
    • Roll-up and Drill-down& Pivot
  3. Informatica Power Center Tool
    • Informatica Tool Overview
    • Introduction to Informatica
    • How developers work on Power Center
    • Different components of Power Center and uses
    • Tasks performed in different Components
    • Mapping, Session, Worklet, Workflow, Mapplet
    • Naming Conventions
    • Designer Component
    • Working with Sources
    • Working with Flat Files
    • Working with Targets
    • Data Transformation Source and Target
    • Mapping Parameters and Variables
    • Uses of Mapping
    • Workflow Manager Component
    • Workflow Manager Overview
    • Workflow Designer
    • Task Developer
    • Worklet Designer
    • Creating a Task
    • Configuring Task
    • Workflow links
    • Validating Tasks,Workflows
    • Scheduling and Running Workflows
    • Workflow Monitor Component
    • Workflow Monitor Overview
    • Using Workflow Monitor
    • Working with Tasks and Workflows
    • Workflow and Task Status
    • Using Gantt Chart and Task Views
    • Session and Workflow Logs
    • Transformation
    • How to use Transformations
    • Aggregator Transformation
    • Expression Transformation
    • Filter Transformation
    • Router Transformation
    • Union Transformation
    • Rank Transformation
    • Sorter Transformation
    • Joiner Transformation
  4. UNIX/LINUX
    • Basics of Unix/Linux
    • Overview of UNIX Operating System
    • Useful Commands
    • Command Manuals
    • Regular Expressions
    • Filter
    • File Attributes
    • Job Scheduling
    • Archive/Compress File
    • Editor : vi, sed
    • Processes
    • File copy/transfer in UNIX Server
    • Shell Script
    • Input/output Redirection
    • Piping
    • Operators
    • Shell Arithmetic
    • Quoting and Escape Mechanism
    • Types of Variables
    • Environment variables
    • Write and execute Shell Program
    • Functions
    • Conditional Statements and Loops

Inquire Now



Student’s Reviews about 3RI