Answer Posted / raghvendra

incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...

Please let me know how to make Data masking in informatica..

1722

---

How can we use mapping variables in informatica? Where do we use them?

1200

---

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

1155

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

---

What is an active transformation?

1110

---

Mention few power centre client applications with their basic purpose?

951

---

Differentiate between router and filter transformation?

1012

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1808

---

What is DR strategy for Informatica project?

1186

---

Is it possible to create multiple domains on a single Informatica server?

1240

---

Explain the tuning lookup transformation - informatica

994

---

What is a repository manager?

1094

---

Which version configuration tool used in ur project?

3258

---

Write the program through which the records can be updated?

1005

---

Can you use flat files in Mapplets.

2651

---