Wel come Ithub online Training Provides Informatica online training
Informatica Online Training Informatica Online Training by Real time Experts: Informatica Online Training Course Content: 1.Introduction to Data ware 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 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
Informatica Online Training
Contact:India: +91 9949599844 USA: +1-347-606-2716 Email: contact@ithubonlinetraining.com
www.ithubonlinetraining.com