Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 6023 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
How to go to the older version for a mapping?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain incremental aggregation in informatica
In which transformation you cannot drag ports into it?
How will the document be delivered to me?
How do you migrate data from one environment to another?
What are the types of caches in lookup?
How to do unit testing in informatica? How to load data in informatica ?
What is status code in informatica?
What do you mean by enterprise data warehousing?
What is a joiner transformation and why it is an active one?
What's the layout of parameter file (what does a parameter file contain?)?
list out all the transformations which use cache?
Explain the different lookup methods used in informatica?
How can you differentiate between powercenter and power map?
