Data Warehousing Training

Lorem ipsum dolor sit amet, consectetur adipiscing elit. M

Informatica Course Content

Basic Data Warehousing Concepts

Data Warehouse
Data Mart
OLAP VS OLTP
Data Warehouse Architecture (Basic)
Data Warehouse Architecture (with a staging area)
Dimensional modeling
Star Schema
Snowflake Schema
Dimensional table
Fact table
Slowly changing Dimension (Type 1,2 and 3)

Power Center Components

Designer
Repository Manager
Workflow Manager
Workflow Monitor

Informatica Concepts and Overview

Informatica Architecture
Source Qualifier
Target Designer
Transofrmations
Mappings
Mapplets
Sessions
Tasks

Sources

Working with relational sources
Working with Flat files

Targets

Working with relational targets
Working with flat file targets

Transformations

Source Qualifier Transformation
Filter Transformation
Joiner Transformation
Sorter Transformation
Union Transformation
Expression Transformation
Sequence Generator Transformation
Router Transformation
Aggregator Transformation
Rank Transformation
Lookup Transformation
Transaction control Transformation
Normalizer Transformation
Stored Procedure Transformation
Update Strategy Transformation

Power Center Transformation Language

Numeric function
String function
Date function
Conversion function
Aggregate function
Cleansing function
User Defined Functions

Advanced Informatica concepts

Unconnected Lookup Transformation
Mapplet and Types of Mapplets
Defining Reusable Transformation
Tasks and Types of Tasks
Scheduling Workflow
Constraint Based Load Ordering
Target Load Plan
Types of Batch Processing
Link Conditions
Mapping Parameters
Mapping Variables
Defining Session Parameters
Session Recovery
Difference between Normal and Bulk Loading
PMCMD Utility
PMREP Utility
Incremental Aggregation
Types of Lookup Caches
Static Lookup Caches
Dynamic Lookup Caches
Persistence lookup Cache
Shared lookup Cache
Sorter and Rank Cache

Task Types

Session
Command
EMAIL
Timer
Event Wait
Event Raise
Decision
Assignment
Control
Worklet