how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 5151 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ramana
sorted input receives the sorted data as input to, improve
the performance of summary calculations
perform sort on group by ports using sorter t/r.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the procedure for creating independent data marts from informatica 7.1?
What is Target Update Override? What is the Use ?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
How to display null values on a target & non-null values on a target?
Explain the tuning lookup transformation - informatica
can we use self join in informaitca?
What is DR strategy for Informatica project?
how did u understand business requirement?
What r the type of indexes u generally used in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
Teradata 
