What are the performance tuning techniques in Informatica?

Complete the following tasks to improve session performance:

• Optimize the target.
• Optimize the source.
• Optimize the mapping.
• Optimize the transformation.
• Optimize the session.
• Optimize the grid deployments.
• Optimize the PowerCenter components.
• Optimize the system.

How can we improve the performance of joiner transformation in Informatica?

Use the following tips to improve session performance with the Joiner transformation:

1. Designate the master source as the source with fewer duplicate key values.
2. Designate the master source as the source with fewer rows.
3. Perform joins in a database when possible.
4. Join sorted data when possible.

How does Informatica improve lookup performance?

Optimizing Lookup Transformations

1. Use the optimal database driver.
2. Cache lookup tables.
3. Optimize the lookup condition.
4. Filter lookup rows.
5. Index the lookup table.
6. Optimize multiple lookups.
7. Create a pipeline Lookup transformation and configure partitions in the pipeline that builds the lookup source.

Which one is better performance wise joiner or lookup in Informatica?

Sometimes joiner gives more performance and sometimes lookups. In case of Flat file, generally, sorted joiner is more effective than lookup, because sorted joiner uses join conditions and caches less rows. Lookup caches always whole file. If the file is not sorted, it can be comparable.

How can mapping performance be improved?

1. Partitioned Mapping Optimization Overview.
2. Use Multiple CPUs.
3. Increase the Maximum Parallelism Value.
4. Optimize Flat Files for Partitioning. Optimize Flat File Sources for Partitioning.
5. Optimize Relational Databases for Partitioning. Optimize the Source Database for Partitioning.
6. Optimize Transformations for Partitioning.

What is busy percentage in Informatica?

The busy percentage is calculated: (run time idle time) / (run time * 100). Each session has a minimum of three threads: reader thread. transformation thread.

How resolve timeout based commit point in Informatica?

To resolve this issue, increase the DTM Buffer size to either 512MB or 1GB (for trial purposes). The DTM size in general can be increased to about three times of the size used with Auto settings.

How do you handle two sessions in Informatica?

8 Answers

1. Go to the session..right click –>start task.
2. If you want to run all the 2 session at one time,enable concurrent workflow option and repeat step 1.
3. To avoid manually running,create unix script which invoke all the 2 sessions using pmcmd.

Why throughput is less in Informatica?

If you have cached lookups, you may see this if the lookup does not fit into memory. The throughput falls off as lookup pages are swapped in and out of memory. It could also be load on the target table due to indexing or transaction logging. But, even 100/sec is nothing great.

What is the difference between static and dynamic cache?

Static Cache gets created once and reused through out the session. Dynamic Cache gets created initially and then data keep inserted/updated during the session. Dynamic cache option is useful when lookup table and target table are same and you have need to update data in cache.

What are thread statistics in Informatica?

Thread statistics are a part of the session log. When you run the workflow, the session log generates the thread statistics, which can provide you with information about the bottlenecks present in Source, Target, or Transformation.