Answer / harish konda

Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.

If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.

The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".

So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.

Answer / rayudu

If the lookup cache doesnt change between mutiple runs and
if we know that the lookup data doesnt change then we will
go for Persistant cache.


If the loopup cache changes between multiple session runs
and to keep the target table and lookup cache synchronized
we will use dynamic lookup cache .

regards,
rayudu.

can any one explain me about junk dimension

4 Answers  

---

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

---

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  

---

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

---

what is target update override and when we use it?

2 Answers   TCS,

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

what is data driven in informatica

5 Answers   IBM,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

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

3 Answers   IBM,

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---