Thursday, 13 September 2012

Informatica Workflow taking more time to execute even after using Sorted input

Sorted input reduces the amount of data cached during the session and improves  the performance of Aggregator. There are chances that you use sorted input in Aggregator still the workflow takes a long time to execute. To avoid such scenarios keep in mind the below points in the mapping or session.
  • Don’t use incremental aggregation in session.
  • Don’t use nested aggregate functions inside aggregate expressions.
  • Also the source data should not be data driven

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...