Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8570 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
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
COM components can be used in Informatica
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the features of complex mapping?
What is the different lookup cache(s)?
Which files are created during the session rums by informatics server?
What are the differences between a connected lookup and unconnected lookup?
Whats there in global repository
What are the various types of transformation?
What is joiner transformation in informatica?
What do think which one is the better joiner or look up?
What is an active transformation?
I have a flat file, want to reverse the contents of the flat file
How big was your fact table
What are junk dimensions?
