Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

What is the benefit of partitioning a session?

0 Answers  

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

Describe data concatenation?

0 Answers  

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

WHat all joins are there in Source Qualifier?

1 Answers  

---