Get the Best Training from IT Experts:    SAP Online Training | Oracle Online Training | Microsoft Online Training | Network/System Admin Online Training | Mobile Online Training | Databases Online Training | Testing Tools Online Training | Datawarehouse Online Training
NeedHelp? Need Help ? +1(214)453-1995

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




• 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




• 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



Request a call back


[email protected]

Request A Call Back
Leave your details and Our training consultant will get back to you asap.
I Agree to be contacted over mail and phone.
Request For A Demo
Register Today for a Free Live Webinar with our Sr. Expert Trainer.
We Don't Share your contact details with others!
100% Privacy Guaranteed.