Answer / amar pandey

the major difference is lookup transformation which is
active(returns all the matched rows) in informatica 9.0

Answer / deepika

In informatica 8.6 unconnected lookup transformation returns only one port and in informatica 9 it returns mutiple matched ports.

Answer / ramana

we can select distinct record using union trans in informatica 9x

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

what is mapping override?

2 Answers   Cap Gemini,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

expain about the tune parameters?

0 Answers   TCS,

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

What is depict expression change?

0 Answers  

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---