what is parallel querying and what r hints.

1 Answers  

---

Types of error logs in Informatica?

2 Answers  

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 Answers   IBM,

---

---

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

0 Answers  

---

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

What are mapplets?

0 Answers  

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---