Answer Posted / munireddy

uning incremental/delta/cdc..

for this we have so many logics some of them are..
using mapping level variable
using control table and ....

Why sorter is an active transformation?

740

---

What is a dimensional model?

571

---

Differentiate between source qualifier and filter transformation?

987

---

what is the -ve test case in your project.

1841

---

Explain informatica architecture - version 8 / 9

655

---

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2418

---

can u any challenge your project?

1594

---

What are pre and post-session shell commands?

725

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

624

---

Write the unconnected lookup syntax?

646

---

Explain the aggregator transformation?

617

---

what is the size of your data warehousing?

1663

---

What is powercenter on grid?

685

---

How are indexes created after completing the load process?

976

---

What is a rank transform?

664

---