Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 6141 Views
- I also Faced
- E-Mail Answers
Answer Posted / srikanth
By using sorted input by performing calculations on groups
of data, informatica server need not to use cache for
holding data to perform calculations for a particular group
as the source data already comes in sorted order. Hence
reduced burden on informatica server, just performing
calculations which is a performance issue.
Ex: for calculating sum of salaries department wise, if
data comes in random order, server need to use cache for
holding data until all the entries for a particular
department is calculated (deptno 10,20....).
by using sorted input, server does not use cache and just
perofrms calculations assuming teh data comes in sorter
order thus improvement in performance.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can you use flat files in Mapplets.
How many transformations can be used in mapplets.
Differentiate between router and filter transformation?
Performance tuning in UNIX for informatica mappings?
How to use procedural logic inside infromatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What do you mean by worklet?
What is meant by target load plan?
Can anyone tell me the new features in Informatica 9 Version?
What is informatica?
Explain your project of banking domian.
How can we improve session performance in aggregator transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are active transformations.
