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 is a standalone command task?

1157

---

What is decode in informatica?

1092

---

update strategy transformation in informatica

1031

---

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

1025

---

Differentiate between reusable transformation and mapplet.

1047

---

What does reusable transformation mean?

1087

---

Do you find any difficulty while working with flat files as source and target?

1063

---

What is the sql query overwrite in source qualifier in informatica

1044

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1641

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

992

---

Explain what transformation and how many are there in informatica?

905

---

How to elaborate powercenter integration service?

1090

---

What is mapplet in informatica?

999

---

can u give example for factless fact table

6486

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1125

---