Informatica Online Training | Informatica Training | Informatica Course online

Informatica Online Training Concepts

• Introduction to Dataware housing (What/Why/How Dataware housing)
• Slowly Changing Dimensions (SCD1, SCD2, SCD3)
• Metadata
• Dimentinal Table
• Types Of Dim Tables
• Fact Table
• Types of Fact Tables
• OLTP (OnLine Transaction Processing)
• OLAP (Online Analysis And Processing)
• OLTP Vs OLAP
• Advantages of OLAP
• 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

• Source Qualifier Transformation
• SQL override in source qualifier transformation
• Source qualifier transformation joins concept
• Source qualifier transformation on Relational Databases
• Source qualifier transformation on File systems
• Source qualifier transformation filter concepts
• Difference Between SQL Override, Other Options
• Source Qualifier Transformation Performance Tunning
• Pre SQL and Post in Source Qualifier Transformation

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

• SCD type1 – Hands-On LAB
• SCD type2 – Hands-On LAB
• SCD type3 – Hands-On 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