Answer / earfgwerf

For more Informatica Interview Questions Click Here

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

Explain what are the different versions of informatica?

0 Answers  

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

how we do performence tuning in informatica

3 Answers  

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

---

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

what transformations are used for Variable port?

2 Answers  

---