Datawarehouse Online Training

Datawarehouse Online Training » Informatica Online Training

 

Informatica Online Training

 

Informatica Online Training Concepts

 

• 1.Introduction to Dataware housing (What/Why/How Dataware housing)
• 2.Slowly Changing Dimensions (SCD1, SCD2, SCD3)
• 3.Metadata
• 4.Dimentinal Table
• 5.Types Of Dim Tables
• 6.Fact Table
• 7.Types of Fact Tables
• 8.OLTP (OnLine Transaction Processing)
• 9.OLAP (Online Analysis And Processing)
• 10.OLTP Vs OLAP
• 11.Advantages of OLAP
• 12.Different Methodologies of DWH

 

PowerCenter Components and User Interface

 

• 1.Informatica PowerCenter Architecture
• 2.Informatica PowerCenter Client Tools
• 3.Start Using of the Designer, Workflow Manager and Workflow Monitor

 

Source Qualifier

 

• 1.Source Qualifier Transformation
• 2.SQL override in source qualifier transformation
• 3.Source qualifier transformation joins concept
• 4.Source qualifier transformation on Relational Databases
• 5.Source qualifier transformation on File systems
• 6.Source qualifier transformation filter concepts
• 7.Difference Between SQL Override, Other Options
• 8.Source Qualifier Transformation Performance Tunning
• 9.Pre SQL and Post in Source Qualifier Transformation

 

Expression, Filter, File Lists and Workflow Scheduler

 

• 1.Expression Editor
• 2.Filter Transformation
• 3.File Lists
• 4.Workflow Scheduler
• 5.Lab – Load the Customer Staging Table and Real time issues

 

Joins, Features and Techniques I

 

• 1.Joiner Transformation
• 2.Shortcuts
• 3.Lab A – Load Sales Transaction Staging Table
• 4.Lab B – Features and Techniques I and Real time issues

 

Lookups and Reusable Transformations

 

• 1.Lookup Transformation
• 2.Reusable Transformations
• 3.Lab A – Load Employee Staging Table
• 4.Lab B – Load Date Staging Table and Real time issues

 

Debugger

 

• 1.Debugging Mappings
• 2.Lab – Using the Debugger

 

Sequence Generator

 

• 1.Sequence Generator Transformation
• 2.Lab – Load Date Dimension Table and Real time issues

 

Lookup Caching, More Features and Techniques

 

• 1.Lookup Caching
• 2.Lab A – Load Promotions Dimension Table
• 3.Lab B – Features and Techniques II
• 4.Review and more Lab Activities and Real time issues

 

Router, update Strategy and Overrides

 

• 1.Router Transformation
• 2.Update Strategy Transformation
• 3.Expression Default Values
• 4.Source Qualifier Override
• 5.Target Override
• 6.Session Task Mapping Overrides
• 7.Lab – Load Employee Dimension Table and Real time issues

 

Dynamic Lookup and Error Logging

 

• 1.Dynamic Lookup
• 2.Error Logging
• 3.Lab – Load Customer Dimension Table

 

Unconnected Lookup, Parameters and Variables

 

• 1.Unconnected Lookup Transformation
• 2.System Variables
• 3.Mapping Parameters and Variables
• 4.Lab – Load Sales Fact Table

 

Sorter, Aggregator and Self-Join

 

• 1.Sorter Transformation
• 2.Aggregator Transformation
• 3.Active and Passive Transformations
• 4.Data Concatenation
• 5.Self-Join
• 6.Lab – Reload the Employee Staging Table and Real time issues

 

SCD type1 – Hands-On LAB

 

SCD type2 – Hands-On LAB

 

SCD type3 – Hands-On LAB

 

Mapplets

 

• 1.Mapplets
• 2.Lab – Load Product Daily Aggregate Table
• 3.Review and more Lab Activities and Real time issues

 

Workflow Variables and Tasks

 

• 1.Link Conditions
• 2.Workflow Variables
• 3.Assignment Task
• 4.Decision Task
• 5.Email Task
• 6.Lab – Load Product Weekly Aggregate Table

 

More Tasks and Reusability

 

• 1.Event Raise Task
• 2.Event Wait Task
• 3.Command Task
• 4.Reusable Tasks
• 5.Reusable Session Task
• 6.Reusable Session Configuration

 

Worklets and More Tasks

 

• 1.Worklets
• 2.Timer Task
• 3.Control Task