Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve performence by using sorted input in aggrigator
t/r.
- 2 Answers
- 5966 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 |
How to do unit testing in informatica?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
What is aggregate cache in aggregator transforamtion?
What is souce qualifier transformation it is active or passive
what is worklet and what use of worklet and in which situation we can use it?
How can you run a session without using server manager?
What are the databases that informatica can connect to windows?
what is constraint based load order
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Teradata 
