Answer Posted / kumarapillaietl@gmail.com

first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.

What are the differences between joiner transformation and source qualifier transformation?

1147

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2320

---

what is Active lock explain

2769

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1059

---

What is the use of transformation?

980

---

Explain in detail about scd type 1 through mapping.

1416

---

What is the difference between a repository server and a powerhouse?

1483

---

What is a node in Informatica?

1027

---

What are the different clients of powercenter?

1040

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2029

---

Where is metadata stored?

1094

---

Explain the pipeline partition with real time example?

1122

---

What is meant by lookup transformation?

1084

---

What is meant by lookup transformation? Explain the types of lookup transformation?

931

---

What is the difference between source qualifier transformations source filter to filter transformation?

1032

---