Answer Posted / tgin

SELECT BOOKID,DECODE(LANGUAGE,'ENGLISH') AS LANGUAGE1,
DECODE(LANGUAGE,'FRENCH') AS LANGUAGE2,
(LANGUAGE,'SPANISH') AS LANGUAGE3
FROM TABLE_NAME
GROUP BY BOOKID

what are the deliverables?in your project?

2197

---

What are different types of transformations available in informatica?

1060

---

What do mean by local and global repository?

1282

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2257

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2797

---

Can we create a Integration service without a Repository service and vice versa?

1260

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

2024

---

Explain why we use partitioning the session in informatica?

1165

---

Is it possible to revert a global repository to local one and why?

1136

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7238

---

can anyone suggest best free Talend data integration training online

1745

---

Is there any way to read the ms excel datas directly into informatica?

1070

---

What is powercenter on grid?

1229

---

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.

1223

---