how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 5336 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 different clients of powercenter?
How to Create a folder using pmrep command?
Explain pushdown optimization $pushdownconfig parameter - informatica
How might one distinguish in the case of mapping is right or not without associating session?
What are the different types of transformation available in informatica.
What is sequence generator transformation in informatica?
Explain sessions and how many types of sessions are there?
Differentiate between router and filter transformation?
What is a node in Informatica?
What is rank index in rank transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a router transformation?
difference between informatica 8.1.1 and 8.6
What is fact table? Explain the different kinds of facts.
Which files are created during the session rums by informatics server?
