Answer Posted / 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.

What is incremental aggregation?

1011

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1439

---

How we can use union transformation?

988

---

Differences between connected and unconnected lookup?

1120

---

What is an expression transformation in informatica?

959

---

What is a passive transformation?

1035

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1032

---

Explain target update override in informatica

1040

---

How to configure mapping in informatica?

1116

---

what is $$$$?

2093

---

How can you validate all mappings in the repository simultaneously?

1284

---

How to create a non-reusable instance of reusable transformations?

1057

---

What are the types of presistent cache in look up tr.

2003

---

During the running session, output files are created by informatica server. Enlist few of them.

927

---

Explain why we use partitioning the session in informatica?

1004

---