Informatica Performance Tuning and Optimization Techniques (Udemy.com)
Partitions, Pushdown Optimization and other Optimization Techniques
Created by: Sid Inf
Last updated March 2019
What you will learn
- Push Down Optimization.
- Partitions in Informatica.
- Dynamic Session Partitions.
- Concurrent Workflow Execution.
- Load Balancing for Workflow Distribution on GRID.
- Steps to determine the best way to improve performance of the existing Informatica Objects.
- Iterative methods of identifying one performance bottleneck at a time and eliminate it.
- Optimization techniquies for Flat File Targets.
- Optimization techniquies for Flat File Sources.
- Optimization techniquies for Mappings.
- Optimization techniquies for Datatype Conversions.
- Optimization techniquies for Expression Transformation.
- Optimization techniquies for Aggregator Transformation.
- Optimization techniquies for Custom Transformation.
- Optimization techniquies for Joiner Transformation.
- Optimization techniquies for Lookup Transformation.
- Optimization techniquies for Normalizer Transformation.
How it compares
Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:
- Rating4.2 out of 5higher than 13% of them
- Reviews340#678 of 1,183 by number of reviews
- Length3.5 hoursshorter than 66% of them
- Last updatedMarch 2019earlier than 90% of them
Course Description
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.
Instructor Details
- 4.2 Rating
340 Reviews
Sid Inf
Business Intelligence Consultant and Trainer with 14+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing 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.
More courses by Sid Inf
Informatica Tutorial: Beginner to Expert Level (2020)
4.5 (8,962 Reviews)
Provider: Udemy
Time: 35.2h
$12.99
Data Warehouse Concepts: Basic to Advanced concepts (2020)
4.0 (2,861 Reviews)
Provider: Udemy
Time: 7.1h
$18.99
More IT & Software courses
D3.js Data Visualization Fundamentals - Hands On (2026)
4.9 (3,917 Reviews)
Provider: Udemy
Time: 4.6h
$49.99
Hands-On Training: Streaming Data with Apache Kafka on Azure (2025)
4.9 (103 Reviews)
Provider: Udemy
Time: 3.7h
$10.99
Oracle Grid Infrastructure and RAC using Oracle Database 19c (2026)
4.8 (2,499 Reviews)
Provider: Udemy
Time: 8.7h
$19.99
PowerShell Scripting & Automation: The Complete Hands-On (2026)
4.8 (1,750 Reviews)
Provider: Udemy
Time: 9.6h
$11.99
AWS EC2 Crash Course + Load Balancing with Demos and PDFs (2025)
4.8 (866 Reviews)
Provider: Udemy
Time: 3.7h
$19.99
Reviews
By Shahjade Alam on 12/12/2021
Its a good course and topic. But Partition logic/eamples expalinations are very less. I would apreciate if you can enhance parition concept by adding more examples.
By Haroon NY Enterprise on 9/21/2020
It was very difficult to hear the instructor with full volume on. The screen was not legible at times because he did not zoom in. The concepts were helpful; however better organization could make this course more attractive.
By Neha Talwar on 5/29/2020
This course is informative but badly needs a couple of complex scenarios that the instructor needs to bring to the table to validate and complete the course for what it has promised to deliver. Although the course imparts information but there's no hands-on of what the real world application and benefit it would bring, I left feeling very underwhelmed after finishing the course and felt it is overpriced due to it's limited nature & content.I would request the instructor to add more realtime complex scenarios that he has earned from his experiences to complete this course.
By Venkata Kandikattu on 3/25/2020
Instructor has exceptional knowledge towards subject and explains most of the details clearly and practically by taking examples.
By Vijaydeep kant khare on 12/20/2019
It is good but while being taken interviews they ask real time examples and complex scenerios so please use them
By Shailesh Kumar Sinha on 10/29/2019
The course was really very helpful in knowing the technical aspects of performance tuning in informatica. The tutor really explained the concepts in a detailed and understandable manner. Appreciate his way of spread learning. Keep it up!!
By Swapnil Gawai on 10/7/2019
Being an ETL Developer working in Informatica, Sid's courses have always helped me quickly have an overview on the topics, which over the course of time I happen to forget due to fade memory. Well paced lectures and I had quite detailed insights on the topics which I had never explored before. Only suggestion I would like to make here is to use tool to quickly zoom in to the dialog windows that appear when you teach us on properties and options that we can undertake as part of amending configurations. I had to open laptop to view those videos clearly as viewing it over mobile was quite difficult. And keep up the good work..:)
By Satyendra Kumar on 1/15/2019
The lectures on Partition and push down optimization are excellent . They are presented in a very organized manner .
By Saswata Dutta on 6/1/2018
This course is very concise explation of informatica performance problem and easy to understand and good starting point of someone who is learning it for the first time.
By Atanu Bera on 5/29/2018
The instructor is knowledgeable no doubt but one thing is missing in the course is real-world and practical examples. Project based teaching could have been a better way to learn the intricacies of the technology in a more lively way. Only theory based learning is not helpful in executing projects in real world.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 84 / 100












