 |
|
|
|
|
|
|
Classifieds: Education / Training | | Informatica onlinetraining | | Posted By: nipuna onlinetraining at: 31, Mar 2012 0:49:38 AM IST | Informatica onlinetraining
Course Name : Informatica online training
Course Duration : 30 Hours
INFORMATICA
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 eynd 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
• Data Concatenation
• Self-Join
• Lab – Reload the Employee Staging Table and Real time issues
SCD type1 – LAB
SCD type2 – LAB
SCD type3 – LAB
Mapplets
• Mapplets
• Lab – Load Product Daily Aggregate Table
• Review and more Lab Activities and Real time issues
Workflow Variables and Tasks
• Link Conditions
• Workflow Variables
• Assignment Task
• Decision Task
• Email Task
• Lab – Load Product Weekly Aggregate Table
More Tasks and Reusability
• Event Raise Task
• Event Wait Task
• Command Task
• Reusable Tasks
• Reusable Session Task
• Reusable Session Configuration
Worklets and More Tasks
• Worklets
• Timer Task
• Control Task
• Lab – Load Inventory Fact Table
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
