What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---

What is degenerated dimention table?

7 Answers   Patni,

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

How do you do error handling in Informatica?

1 Answers  

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

---

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

0 Answers  

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---