Informatica Performance Tuning and Optimization Techniques
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Partitions, Pushdown Optimization and other Optimization TechniquesDescription
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.
Requirements
- Requirements
- You should know Informatica Power Center
- ETL Methodologies using Informatica Power Center
Knowledge
- 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.
- Optimization techniquies for Sequence Generator Transformation.
- Optimization techniquies for Sorter Transformation.
- Optimization techniquies for Source Qualifier Transformation.
- Optimization techniquies for SQL Transformation.
- Optimization techniquies for the Sessions.
- Optimization techniquies for Grid Deployment.
- Optimization techniquies for the (Operating Systems) Systems.
- Optimizing Buffer Block Sizes.
- Optimizing Cache Sizes for Cache using transformations.
Informatica Tutorial: Beginner to Expert Level
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Become an expert in world's top Data Integration tool. Informatica Power Center tool supports all the steps of Extraction, Transformation and Load process/life cycle....
Machine Learning Optimization Using Genetic Algorithm
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn how to optimize Machine Learning algorithms' performances and apply feature selection using Genetic Algorithm It is referred to as hyperparameter tuning or parameter tuning....
Combinatorial Problems and Ant Colony Optimization Algorithm
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Let's learn Artificial Intelligence search methods: optimization, exact algorithms, heuristics, and metaheuristics Search methods and heuristics are of the most fundamental Artificial Intelligence techniques....
Art and Science of Machine Learning
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Welcome to the Art and Science of machine learning. This course is delivered in 6 modules. Introduction Course Introduction Getting Started with Google Cloud Platform and Qwiklabs...
