Answer / deepak aggarwal

You can calculate the size of lookup cache file needed
from number of rows and colulmn width needed. You can
increase Cache file size for good performance.

Answer / priya

There are 2 ways :
1. Create a persistant cache
2. Add the lookup table in SQ make it outer joined

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---

can we use cartesian join in informatica

3 Answers   IBM,

---

what is lookup chache?

1 Answers   Patni,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

how do u tune queries?

1 Answers  

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---

What is repository manager?

0 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

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,

---