how to improve performence by using sorted input in aggrigator
t/r.
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 |
Explain the difference between mapping parameter and mapping variable?
What are different types of transformations available in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is incremental aggregation?
What is difference between a gateway node and worker node?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
what are factless facts? And in which scenario will you use such kinds of fact tables.
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
Can we use the mapping parameters or variables created in one mapping into another mapping?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
why union transformation is active transformation?
Can anyone please distinguish what is Inner join and Outer join