Informatica Performance Tuning and Optimization Techniques
Partitions, Pushdown Optimization and other Optimization Techniques
The purpose of this course is to walk you through the steps to identify performance bottlenecks in Informatica Power Center and different optimization techniques to fix them. After completing this course, you will have a working understanding of the different performance bottlenecks, how to identify them based on the iterative approach and the thread statistics. Different best practices and optimization techniques which should be consideration while designing the mapping or fine tuning the existing ones.
Data Management and Business Intelligence Consultant/Trainer with 16+ years of extensive work experience on various client engagements. Delivered many large Data Management projects (Data Integration, Data Quality, Data Governance, Metadata Management, Master Data Management, Data Security, Data Catalog etc) and trained numerous professionals on various tools and technologies. Extensively worked on all facets of Data Managment including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.
Has worked on broad range of business verticals and hold exceptional expertise on various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.
StartThe back stage artists - Session's Anatomy (1:57)
StartWhat are Source Bottlenecks? (3:49)
StartWhat are Target Bottlenecks? (1:34)
StartWhat are Transformer Bottlenecks? (3:03)
StartWhat are Session Bottlenecks? (3:24)
StartWhat are System Bottlenecks? (2:53)
StartSummary of Bottlenecks (2:42)