to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
- 3 Answers
- 7857 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhupal
if u wont use the sorted input the aggregator transformation will reads the records and keep until all the calculations are done.
if we provided the sorted input it reads the records and release the records reaching next first record of new group.
the integration service will creates the cache for only the sorter keys and only one cache in sorter t/r. so by providing the sorted input we get the performance advantage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the informatica performance improvement tips
What is a stored procedure transformation?
What is a repository? And how to add it in an informatica client?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What do you mean by blocking transformation?
In development project what is the process to follow for an etl developer from day1
What is the need for an etl tool?
Parameter and variable differences
What is meant by lookup transformation?
What is Data Caches size?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Is stop and abort are same in informatica?
How to implement security measures using repository manager?
What are the tasks that source qualifier perform?
can we override a native sql query within informatica? How do we do it?
