Course Duration in Hours
60
60
Data Warehousing Concepts:
Data Warehouse
Data Mart
OLAP VS OLTP
Data Warehouse Architecture
Dimensional Modeling
Star Schema
Snowflake Schema
Fact & Dimensions
Types of Facts and Types of Dimensions
Change Data capture
Informatica Power Center 9
1. Power Center Components
Repository Manager
Designer
Workflow Manager
Workflow Monitor
2. Informatica Concepts and Overview and Architecture
Designer Components
Source Qualifier
Target Designer
Transformation developer
Mapplet designer
Mapping designer
Workflow Manager Components
Task Developer
Worklet Designer
Workflow Designer
3. Sources
Working with relational Sources
Working with Flat Files
4. Targets
Working with Relational Targets
Working with Flat file Targets
5. Transformations
Filter Transformation
Router Transformation
Sorter Transformation
Union Transformation
Joiner Transformation
Source Qualifier Transformation
Expression Transformation
Aggregator Transformation
Rank Transformation
Sequence Generator Transformation
Normalizer Transformation
Stored Procedure Transformation
Transaction Control Transformation
Update Strategy Transformation
XML Source Qualifier Transformation
Lookup Transformation
Mapplet Input
Mapplet Output
6. Power Center Supported Functions(Optional)
Numeric functions
String Functions
Date Functions
Conversion Functions
Cleansing Functions
Aggregate Functions
Level 2 Advanced Level
Versioning (Check out,Check in)
Shared Folders
Short Cuts
User Defined Functions
Scheduling Informatica Jobs
Error Handling
Mapping Parameters
Mapping Variables
Session Parameters
Debuggining the Mappings
Informatica Object migration from Folder to Folder and Environment to Environment
Unconnected lookup Transformation
Unconnected Stored Procedure
Defining Reusable Transformations.
Mapplet and Types of Mapplets
Worklet and Types of Worklets.
Constraint Based Load Ordering.
Target Load Plan
Types of Batch Processing
Difference Between Normal and Bulk Loading.
Session Recovery
Push Down Optimization.(Optional)
PMCMD Utility
Incremental Aggregation
Caches and types of caches
Aggregator
Sorter
Rank
Joiner
Lookup
Types Of LookUp Caches.
Static LookUp Cache
Dynamic LookUp Cache
Perisistance lookup Cache
Shared LookUp Cache
Re Cache
Task Implementations.
Link
Session
Command
EMAIL
Timer
Event Wait
Event Raise
Decision
Assignment
Control
Worklet
Required basic Sql
Elegant IT Services, Marathahalli (Bangalore),Bangalore,IN