Answer Posted / abhishek.x.upadhyay

There are two types of Lookup Cache options -

1. Dynamic cache.
2. Persistent cache

1. dynamic Cache - The Dynamic cache is a property of the
look up which if selected makes other ports of the same
record to be checked as Look up apart from the Look up port.

2. Persistent Cache - persistent cache is something like on
the first run the lookup table values gets into a cache and
is stored on the server's hard disk. Each time the run is
made the values would be looked up from this cache only.

Persistent cache is done only when the lookup has to be
made on same set of values each time.

how do u set partition points in the mapping?

2174

---

what is the main role of FI on business

2031

---

What are various etl tools in the market?

936

---

how to connect to a flatfile through ftp in informatica

14176

---

can cubes contain measures ?

1978

---

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2106

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1746

---

Compare etl & elt?

946

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2492

---

Explain about round-robi?

1076

---

what happens if the info.server doesn't find the session parameter in the parameter file?

1872

---

Is apache nifi an etl tool?

906

---

Difference between flat files and relational sources?

2216

---

What is a staging area? What is the purpose of a staging area?

824

---

What is lookup table in etl testing?

1115

---