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

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 Between Normal and Bulk Loading
• Push Down Optimization
• PMCMD Utility
• PMREP 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

ETL Testing

• UNIT Testing
• System Integration testing
• PERFORMANCE TESTING
• ETL Performance Optimization techniques