Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 6068 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 is union transformation?
What is a filter transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What does role playing dimension mean?
Explain the code page compatibility?
COM components can be used in Informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the meaning of decode in informatica?
Mention few power centre client applications with their basic purpose?
How would you join a node to the already existing domain?
What is the use of target designer?
What are the new features of informatica 9.x in developer level?
