Skip to content
UdemyIT & SoftwarePaid courseBeginner levelCertificate

Informatica Performance Tuning and Optimization Techniques (Udemy.com)

Partitions, Pushdown Optimization and other Optimization Techniques

Created by: Sid Inf

Last updated March 2019

icon
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

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Sid Inf

$12.99

$11.99

$18.99

$10.99

$59.99

$11.99

icon
More IT & Software courses

$49.99

$10.99

$124.99

$19.99

$11.99

$19.99

icon
Reviews

4.2

340 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 340 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100