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
Email

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

 

 

Request a call back

+1(214)453-1995

[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.