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.?

Answer Posted / james

Sorted input in an aggregator transformation does not use
cache instead it uses the memory. Reading from memory is
faster than reading from cache.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers using expression transformation?

838


How can we improve session performance in aggregator transformation?

893


What is a node in Informatica?

818


How to extract sap data using informatica?

800


How can you increase the performance in joiner transformation?

936


wf dont have integration severances how you can run?

1720


Explain dynamic target flat file name generation in informatica

848


Explain about Informatica server process that how it works relates to mapping variables?

824


State the differences between sql override and lookup override?

862


without table how to come first record only in oracle?

2041


where to store informatica rejected data?

850


What is decode in informatica?

827


What is the benefit of session partitioning?

824


wat are deployement groups in informatica, how it will be used for developers

1455


What is the reusable transformation?

832