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.

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.

What is galaxy shema

2 Answers   CGI,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

what is materialized view?

2 Answers  

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---