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.

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

What are the joiner caches?

3 Answers   Informatica,

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

What is DTM process?

4 Answers  

---

How can u stop a batch?

2 Answers  

---

What are the tuning techniques you applied during your last project

0 Answers  

---

How to merge First Name & Last Name?

8 Answers  

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

Explain transaction control transformation in informatica

0 Answers   Informatica,

---