INFORMATICA ONLINE TRAINING

Informatica  Course Content
Data Warehousing Concepts
	Data Warehouse
	Data Mart
	OLAP VS OLTP
	Data Warehouse Architecture (Basic)
	Dimensional Modeling
	Star Schema
	Snowflake Schema
	Dimension
	Fact
	Slowly Changing Dimension
	Hierarchy
	Confirmed Dimension
	Fact less Fact
	Summary / Aggregations table
	Change Data capture
E T L Informatica Power Center 9
Power Center Components
	Designer
	Repository Manager
	Workflow Manager
	Workflow Monitor
Informatica Concepts and Overview
	Informatica Architecture.
	Source Qualifier
	Target Designer
	Transformations
	Mappings
	Mapplets
	Sessions
	Tasks
Sources
	Working with relational Sources
	Working with Flat Files
Targets
	Working with Relational Targets
	Working with Flat file Targets
Transformations
	Expression Transformation
	Lookup Transformation
	Sequence Generator Transformation
	Filter Transformation
	Joiner Transformation
	Sorter Transformation
	Procedural Transformation
	Router Transformation
	Aggregator Transformation
	Update Strategy Transformation
	Union Transformation
	Rank Transformation
	Transaction Control Transformation
	Normalizer Transformation
	Source Qualifier Transformation
	Stored Procedure Transformation
	XML Source Qualifier Transformation
	Debugging Mappings
Power Center Transformation Language
	Numeric functions
	String Functions
	Date Functions
	Conversion Functions
	Cleansing Functions
	Aggregate Functions
	User Defined Functions
ADVANCED INFORMATICA CONCEPTS
	Unconnected lookup Transformation
	Unconnected Stored Procedure
	to Create and Drop Index
	Mapplet and Types of Mapplets
	Defining Reusable Transformations.
	User Defined Functions.
	Tasks And Types of Tasks.
	Worklet and Types of Worklets.
	Scheduling Work flow
	Constraint Based Load Ordering.
	Target Load Plan
	Types of Batch Processing
	Link conditions
	Mapping Parameters
	Mapping Variables
	Defining Session Parameters
	Session Recovery
	Difference B/W Normal and Bulk Loading.
	Push Down Optimization.
	PMCMD Utility
	PMREP Utility
	Incremental Aggregation
	TYPES Of LookUp Caches.
	Static LookUp Cache
	Dynamic LookUp Cache
	Perisistance lookup Cache
	Shared LookUp Cache
	Sorter and Rank Cache.
ETL UNIT Testing
ETL PERFORMANCE TESTING
ETL Performance Optimization techniques
Task Implementations.
	Command
	EMAIL
	Timer
	Event Wait
	Event Raise
	Decision
	Assignment
	Control
	Worklet