Answer Posted / rekha

IN GENERAL DATABASE OPERATONS ARE MORE FASTER THAT
EXEXUTING IN THE POWERCENTER,SO WE CAN MOVE THE COMPLEX
TRANSFORMATION LOGIC TO DATABASE FOR PERFORMNACE IMPROVE

What are data-driven sessions?

716

---

can you please explain me pre session and post session options?

6387

---

Implementation methodology

1264

---

How do you load first and last records into target table?

669

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6417

---

---

When do you use sql override in a lookup transformation?

590

---

How to extract sap data using informatica? What is abap? What are idocs?

560

---

How to update source definition?

634

---

explain one complex mapping with logic? sales project?

6154

---

Explain in detail scd type 2 through mapping.

619

---

can u give example for factless fact table

5527

---

Explain the difference between a data warehouse and a data mart?

600

---

list out all the transformations which use cache?

691

---

Explain the code page compatibility?

643

---

How to do unit testing in informatica?

725

---