Answer / san

when the table you are using for lookup is static table(
i.e. data is not changing ) and it is the huge table.
Hence reduce the session time by using the persistent cache
file/s.
Regards,

Answer / kvikas2056

If you are using multiple look up transformations on same table, at that time you can use persistent named cache.

What are the ETL Testing Operations?

0 Answers  

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  

---

What are the differences between sql override and update override?

0 Answers  

---

What is the difference between Data Warehousing and Data Mining?

0 Answers  

---

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  

---

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

What is tracing level? How many types of transformations supported by sorted input?

0 Answers  

---

what are the data modeling tools you have used?(polaris)

0 Answers  

---

List few etl bugs?

0 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

What is lookup table in etl testing?

0 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 Answers  

---