Informatica Performance Improvement
1. Run the batches concurrently for all independent batches.
2. Cache the look-ups for better performance.
3. For best performance at runtime, source files should be placed on the server machine.
4. For better performance filter the data as close to the source as possible (limiting the amount of data through the transformations).
5. Split the mappings wherever possible to increase the performance.
6. Implement Parallel Processing for increasing the performance.
7. Do not have many targets in a single session. Split the sessions based on Targets.
8. Do not use many aggregators in a single mapping. Anything more than 2 aggregators are not advisable in a single mapping.
1. Run the batches concurrently for all independent batches.
2. Cache the look-ups for better performance.
3. For best performance at runtime, source files should be placed on the server machine.
4. For better performance filter the data as close to the source as possible (limiting the amount of data through the transformations).
5. Split the mappings wherever possible to increase the performance.
6. Implement Parallel Processing for increasing the performance.
7. Do not have many targets in a single session. Split the sessions based on Targets.
8. Do not use many aggregators in a single mapping. Anything more than 2 aggregators are not advisable in a single mapping.
Comments (0)
- No comments yet.
