Answer Posted / anushka jain

Lookup Cache boost the performance of look up by reading the data from lookup source only once and then using it for for rest of the mapping. We can enable the Cache by checking the “Lookup caching Enabled” in the Properties tab of lookup Transformation.
Different Type of Cache are
1.static cache
2.dynamic cache
3.persistant cache
4.shared cache

I found a very good article at below link .
http://www.tecktricks.com/types-of-lookup-cache-in-informatica/
I hope it will benefit you :)

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1261

---

Explain load alternative records / rows into multiple targets - informatica

1150

---

what is the size of u r source(like file or table)?

2270

---

What do you mean by worklet?

1064

---

What is sequence generator transformation in informatica?

1074

---

What is union transformation in informatica?

1146

---

What is meant by LDAP users?

1202

---

Which transformation is needed while using the Cobol sources as source definitions?

1168

---

How to elaborate tracing level?

1172

---

Is it possible to use a client with different version than that of its Informatica server?

1135

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

---

What does cheating measurement mean?

1051

---

what are 3 tech challenges/ common issues you face?

2344

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10678

---

What is meant by lookup transformation? Explain the types of lookup transformation?

943

---