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

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

What is polling?

1 Answers  

---

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

---

What is incremental aggregation?

0 Answers  

---