2013-01-03

Description:

H2Kinfosys online training provides the best informatica online training with industry experts.Informatica real time experts will

share their knowledge,project experiences,tips in informatica real time scenarios in our online training program.Informatica job

oriented online training with live projects, we provide a Live project experience by the expert trainers.

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

Dynamic Lookup and Error Logging

Dynamic Lookup
Error Logging
Lab - Load Customer Dimension Table

Unconnected Lookup, Parameters and Variables

Unconnected Lookup Transformation
System Variables
Mapping Parameters and Variables
Lab - Load Sales Fact Table

Sorter, Aggregator and Self-Join

Sorter Transformation
Aggregator Transformation
Active and Passive Transformations
Da

Show more