Answer Posted / kamleshmishra291

SELECT * FROM TABLE_NAME PIVOT( MAX(SALES) FOR REGION IN (1,2));

What do you understand by SOA of Informatica?

992

---

Explain the mapping variable usage example in informatica

1167

---

What is the cumulative sum and moving sum?

1186

---

Can u generate reports in Informatica?

1091

---

How to create Target definition for flat files?

1228

---

How we can use union transformation?

1054

---

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

1123

---

Explain in detail scd type 2 through mapping.

1046

---

How to do unit testing in informatica?

1177

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1088

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1109

---

What are the different components of powercenter?

1055

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

---

design of staging area?

2030

---

How to load the data from people soft hrm to people soft erm using informatica?

1021

---