Answer Posted / srinu

Joiner :- Catch Performance will work based on
Master,Detail Column,Data catch,Index
catch ,Catch Size also.
(Process Begins with Condition,Comparing, Indexing)

No Catch :-With out Catch, its not easy find(5 records)
Relavtive Data.

Static ;- Catch will Keep the Target Rows to Compare with
Sourece Rows.
(Process Begin with Condition,Comparing).

Dynamic :- The Catch Data will be Update on DataFlow
also. ,,,

Enlist the differences between database and data warehouse.

1121

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1632

---

Enlist the tasks for which source qualifier transformation is used.

1040

---

What the difference is between a database, a data warehouse and a data mart?

1155

---

What is joiner change?

1148

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2423

---

What is the sequence generator transformation in informatica?

1184

---

How to update a particular record in target with out running whole workflow?

1576

---

In warehouses how many schemas are there?

1073

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1094

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5676

---

COM components can be used in Informatica

2392

---

What is meant by a domain?

1128

---

Explain the scenario which compels informatica server to reject files?

1168

---

How is union transformation utilized?

1009

---