Etl And Informatica Topics t3l5f

ETL Testing Concepts

by Dinesh

•

DataWareHousing Concepts

•

What is Data Ware House?

•

Difference between OLTP and DataWare Housing

•

Data Acquisition

•

Data Extraction

•

Data Transformation

•

Data Loading

•

Data Marts

•

Dependent Data Mart

•

Independent Data Mart

•

Data Base Design

•

Star Schema

•

Snow Flake Schema

•

SCD(slowly changing dimension)

•

Type-1 SCD

•

Type-2 SCD

•

Type-3 SCD

Informatica tool Transformations

•

Basic Concepts in SQL

•

Overview of ETL Tool Architecture

•

White Box and Black BOX Testing Functionality on Different Transformation Rules

•

Data Ware House Life Cycle

•

Different Types of Testing Techniques in ETL

•

Minus Queing

•

Count Queing

•

ETL Testing Concepts

.

Informatica Transformations and their functionality

•

Introduction

•

What is use of testing

•

What is quality & standards

•

Responsibilities of a ETL Tester

•

2.Software development life cycle

•

Waterfall model

•

V-model

•

Agile model & methodology

•

White box testing

•

Black box testing

•

Grey box testing

•

ETL Testing Work Flow Process

•

How to Prepare the ETL Test Plan

•

How to design the Test cases in ETL Testing.

•

How to reporting the Bugs in ETL Testing ?

•

ETL Testing Responsibilities in DataStage, Informatica, Abinitioetc;

•

How to detect the bugs through database queries

•

ETL Performing Testing & Performing Tuning

•

Basic Unix concepts

INFORMATICA TOPICS



DataWareHousing Concepts

 What is Data Ware House? 

Difference between OLTP and DataWare Housing



Data Acquisition



Data Extraction



Data Transformation



Data Loading



Data Marts



Dependent Data Mart



Independent Data Mart



Dataware house Design



Star Schema



Snow Flake Schema

 Informatica client tools Designe Workflow Manager Work flow monitor  Informatica Transformations a) Expression Transformation b) Lookup Transformation c) Sequence Generator Transformation d) Filter Transformation e) er Transformation f) Sorter Transformation g) Procedural Transformation h) Router Transformation i) Aggregator Transformation

j) Update Strategy Transformation k) Union Transformation L) Rank Transformation M) Transaction Control Transformation N) Normalizer Transformation O) Source Qualifier Transformation P) Stored Procedure Transformation Q) XML Source Qualifier Transformation  Mapplets  Reusable Transformations  SCD(slowly changing dimension) • Type-1 SCD • Type-2 SCD • Type-3 SCD  Tasks  Advanced Concepts  SQL Concepts  UNIX concepts  Informatica Interview Questions, Scenarios and Problems  Responsibilities of Informatica Developer For further queries E mail us on

[email protected]

Thank you

for those who seek Informatica training

for those who seek ETL Testing training