Answer / praveen n

Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static

Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---

design of staging area?

0 Answers  

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

What is the Hierarchy of DWH?

1 Answers  

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

---

what is $$$$?

0 Answers   TCS,

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

What is enterprise data warehousing?

0 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

In warehouses how many schemas are there?

0 Answers  

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---