Answer Posted / ravi

select * from table_name pivot(sum(sales) for region in(1,2));

Explain sessions?

979

---

What is Data Caches size?

1032

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2058

---

What is DR strategy for Informatica project?

1114

---

What are the different types of repositories created using informatica?

1060

---

In informatics server which files are created during the session rums?

1063

---

tell me the rules and responsblites in our project(my project is development)

1874

---

Implementation methodology

1654

---

What is InformaticaPowerCenter?

1074

---

list out all the transformations which use cache?

1112

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2797

---

What is the benefit of partitioning a session?

1102

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

---

What are the mapping parameters and mapping variables?

1087

---

What is the function of look up transformation?

1054

---