Faculty: Informatica Certified consultant

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
 Dimension
 Fact
 Slowly Changing Dimension(Type 1,2 and3)
 Hierarchy
 Confirmed Dimension
 Fact less Fact Table.
 Summary / Aggregations table
 Change Data capture

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

ADVANCED INFORMATICA CONCEPTS
 Unconnected lookup Transformation
 Unconnected Stored Procedure to Create and Drop Index
 Mapplet and Types of Mapplets
 Defining Reusable Transformations.
 Tasks And Types of Tasks
 Worklet and Types of Worklets
 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
 Push Down Optimization
 PMCMD Utility
 Incremental Aggregation

TYPES Of LookUp Caches
 Static LookUp Cache
 Dynamic LookUp Cache
 Persistence lookup Cache
 Shared LookUp Cache
 Sorter and Rank Cache

Task Types
 Session
 Command
 EMAIL
 Timer
 Event Wait
 Event Raise
 Decision
 Assignment
 Control
 Worklet