Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 6047 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
Reusable transformation and shortcut differences
Informatica settings are available in which file?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is informatica?
What are the types of lookup transformation?
What do you mean by worklet?
What is domain and gateway node?
Can we get 1st record through Informatica(without sequence number).
How can we use mapping variables in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is persistent lookup cache?
What is the difference between stop and abort in informatica
How does the aggregator transformation handle null values?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
