training21 Posted March 27, 2019 Report Posted March 27, 2019 Selfpacedtech is the best Online Training provider worldwide with real time experts : Informatica Course Content : Data Warehousing Concepts Dataware housing (what is Dataware housing /Why Dataware housing/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 InformaticaPowerCenter Architecture InformaticaPowerCenter Client Tools 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 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 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 Re-usability 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 Contact US : 309 - 200 - 3848 / 2019051656 / +91 9030990003 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.