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
- 8457 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
Does an informatica transformation support only aggregate expressions?
Sequence generator, when you move from develoment to production how will you reset
What is a node in Informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
How might one distinguish in the case of mapping is right or not without associating session?
What are the various types of transformation?
What does command task mean?
How do you update the records with or without using update strategy?
Can we create a Integration service without a Repository service and vice versa?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Define mapplet?
What is the Rank index port in Rank transformation?
What is sorter transformation?
what is INFORMATICA TESTING process
How to improve the performance of a session using sorter transformation?
