Datawarehouse Online Training » Informatica Online Training
Informatica Online Training
Informatica Online Training Concepts
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