Answer / mike

The informatica server builds a cache in the memory when it
process the first row of a cached lookup transformation.It
allocates the memory based on the amount you configure in
the trandformation or session properties.The informatica
server stores the conditional values in the index cache and
data values in the data cache..
correct me if i was wrong

what is diffrence b/w joner and union transfermation

6 Answers  

---

what is session override?

2 Answers   Cap Gemini,

---

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

0 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

---

Kimball and Inmon methodologies?

2 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

What is dynamic cache?

0 Answers  

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

can we use self join in informaitca?

3 Answers   IBM,

---