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

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

How to elaborate powercenter integration service?

0 Answers  

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

What is a node in Informatica?

0 Answers  

---

How will u pas the data with out debugger?

4 Answers  

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

EXL informatica Questions

0 Answers  

---

What is target designer and target load order?

0 Answers  

---