Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 6145 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 |
where does the default group roew in a router is stored what is the default size of memory in router
Examples of Fatal & Non-Fatal error?
why we are using surogate key in real time give me explanation
What do you mean by enterprise data warehousing?
explain different types of modeling.
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
if the session fails after 100 records agian we have to starts the session or we go for recovery session
What are the popular informatica products?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
can every transfomation reusable?how?
How to fix the etl bugs..Tell me the process?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
Teradata 
