Answer / ashis

When we use dynamic lookup the process is as follows:
1. When the first record is read from the lookup
table/flatfile, server keeps the value in the RAM also the
same information is written into two auto generated files
(having random names, forgot the type, hope it is something
related to index and cache).
2. When the next record comes for lookup, first the record
is searched in the RAM or created file based on the
conditions used in lookup condition.
3. If not found then searched in the Lookup table.
4. In case of dynamic lookup once value is fetched from the
source with modified fields it will be updated in the RAM
or autogenerated file for further lookup for same key
values, before the completion of the session.
(Example:- in case if emp_id 101 got modified more than one
time between the two runs).

5. In case of static lookup. It will always look into the
already existing value in the lookup table.

Answer / padmavathi

What Ashis told is Exactly correct apart of this Actually
when lookup table contains less data then we will go for
the Dynamic Lookup cache, performance increases.If large
data is there means its better to go for static cache.

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

What is the meaning of decode in informatica?

0 Answers  

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

How to recover sessions in concurrent batches?

1 Answers  

---