Informatica course for Working professional by Lara Tech

Informatica
DWH Concepts
Introduction to Data Warehousing
What is Data Warehousing? And why data warehousing required?
Data Warehouse Architectures
What is OLTP,OLAP
Steps to Transform OLTP to OLAP
Data Warehousing Life Cycle
What is ODS
Different types of Data Warehouse Approaches
Definition of Data Mart
Dependant Data Marts
Independent Data Marts
Difference between Data Mart and Data Warehouse
Data modeling
Different types of Dimensional Modeling
Multi-Dimensional Modeling
Star schema
Snow flake schema
Galaxy schema
What is dimension?
What is Fact?
Start Schema
Fact Table
Dimensional Tables
Snow Flake Schema
Factless Fact Table
Confirmed Dimensions
What is SCD and types of SCD,s
ETL Project Architecture
Types of Data Processing
Data Cleansing
Data Merging
Data Aggregation

Informatica 9.1.0
1. Introduction
Overview
Informatica history
Intormatica Architecture
Power Center / Power Mart

2. Informatica Designer Introduction
Introduction of Power Center Designer
Source Analyzer
Target Designer
Transformation Developer
Mapplet Designer
Mapping Designer
Defining Sources
Defining Targets

3. Informatica Designer
Mapping Introduction
Ports
Mapping Table to Table
Mapping Flat File to Table
Mapping Table to Flat File
Mapping Flat File to Flat File
SCD1
SCD2
SCD3

Transformations
Active and Passive Transformation
Connected/Unconnected Transformations
Type of transformations
Aggregator Transformation
Expression Transformation
External Procedure Transformation
Filter Transformation
Input Transformation
Java Transformation
Joiner Transformation
Lookup Transformation
Normalizer Transformation
Output Transformation
Rank Transformation
Reusable Transformation
Router Transformation
Sequence Generator Transformation
Sorter Transformation
Source Qualifier Transformation
SQL Transformation
Stored Procedure Transformation
Transaction Control Transaction
Union Transformation
Update Strategy Transformation
4. Infformatica-Workflow Manager
Workflow Introduction
Tasks
Workflow tools
Connections
Defining tasks
(i) Command tasks
Setting Properties of Session Task
Creating Workflow
Starting Workflow
Monitoring Workflow
5. Informatica Advanced Features

Incremental Aggregation
Mapplet Implementation
Target Load Plan
Constraint Based Loading
Mapping Parameters
Mapping Variable
Session Parameters
Task and Types of Tasks
Work let and types of work lets
Scheduling Workflow
task and event wait task
Perform testing ETL
Unit Testing ETL
Incremental Loading
Performance Tuning