Informatica Online Beginner level by STAR IT TECHNOLOGIES

DATAWAREHOUSING CONCEPTS:
INTRODUCTION TO DATAWAREHOUSING
Data Warehousing Concepts
Dataware housing (what/Why/How)
Data Modelling(Schemas, FACTS and DIMENSIONS)
Slowly Changing Dimensions
Metadata
PowerCenter Components and User Interface
PowerCenter Architecture
PowerCenter Client Tools
Lab Using the Designer and Workflow Manager
Source Qualifier
Source Qualifier Transformation
Lab Project Overview
Lab A Load Payment Staging Table
Source qualifier Joins
Lab B Load Product Staging Table
Source Pipelines
Lab C Load Dealership and Promotions Staging Table and Real time issues
Expression, Filter, File Lists and Workflow Scheduler
Expression Editor
Filter Transformation
File Lists
Workflow Scheduler
Lab Load the Customer Staging Table and Real time issues
Joins, Features and Techniques I
Joiner Transformation
Shortcuts
Lab A Load Sales Transaction Staging Table
Lab B Features and Techniques I and Real time issues
Lookups and Reusable Transformations
Lookup Transformation
Reusable Transformations
Lab A Load Employee Staging Table
Lab B Load Date Staging Table and Real time issues
Debugger
Debugging Mappings
Lab Using the Debugger
Sequence Generator
Sequence Generator Transformation
Lab Load Date Dimension Table and Real time issues
Lookup Caching, More Features and Techniques
Lookup Caching
Lab A Load Promotions Dimension Table
Lab B Features and Techniques II
Review and more Lab Activities and Real time issues
Router, update Strategy and Overrides
Router Transformation
Update Strategy Transformation
Expression Default Values
Source Qualifier Override
Target Override
Session Task Mapping Overrides
Lab Load Employee Dimension Table and Real time issues