Professional Training on ETL Testing

No Reviews Yet

Pimple Saudagar, Pune

Course ID: 45466

Pimple Saudagar, Pune

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

About 3RI Technologies Pvt Ltd

We have almost 25 trainers with us for all different technologies, we have associated with so many people in the IT industry who actually works on the real time projects have may years of expertise experience, they share their knowledge as a KT sessions or visiting faculty.
No reviews currently Be the First to Review

About the Course

ETL Testing - Informatica


Duration: 7-8 Weekend (Sat/Sunday Batch)


Prerequisites



  • Knowledge of Manual Testing

  • Knowledge of DBMS/SQL basics is advantageous.


Course Content





  1. Database/SQL



  • RDBMS Concepts

  • Data Models

  • Entity Relationship Model

  • Normalization

  • DBMS, RDBMS, ORDBMS

  • SQL Overview

  • Introduction to SQL

  • Data types

  • SELECT Statement

  • Operators

  • Pseduo 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



  1. Datawarehouse/ETL



  • Datawarehouse Fundamental

  • Datawarehouse Overview

  • DWH Characteristics

  • Types of Datawarehouse

  • Data Mart

  • Database vs Data Warehouse

  • Data Mart vs Data Warehouse

  • Data Warehouse benefits

  • DWH Architecture

  • Datawarehouse 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

  • Star, Snow-flake and Galaxy 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

  • Types of ETL Testing

  • How to create ETL Test Case

  • 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

  • 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 Wizards

  • Workflow Manager Component

  • Workflow Manager Overview

  • Workflow Designer

  • Task Developer

  • Worklet Designer

  • Using Workflow Wizard

  • 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


 


 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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for ETL Training Post your requirement now

Enquire

Submit your enquiry for Professional Training on ETL Testing

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With 3RI Technologies

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more