Answer / swetha

Persistent cache: yoU can save the lookup cache files and
reuse them the next time the informatica server processes a
lookup transformation configured to use the cache.

Recache from database: If the persistent cache is not
synchronized with he lookup table, yoU can configure the
lookup transformation to rebuild the lookup cache.

Static cache: U can configure a static or readonly cache for
only lookup table. By default informatica server creates a
static cache. It caches the lookup table and lookup values
in the cache for each row that comes into the
transformation. when the lookup condition is true, the
informatica server does not update the cache while it
prosesses the lookup transformation.

Dynamic cache: If you want to cache the target table and
insert new rows into cache and the target, you can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.

shared cache: yoU can share the lookup cache between
multiple transactions.yoU can share unnamed cache between
transformations inthe same maping.

Answer / yallu

Types of lookup caches :
1.persistant cache
2.static cache
3.dynamic cache
4.shared cache
5.recache from source

Answer / sridhar

Persistent cache: U can save the lookup cache files and
reuse them the next time the informatica server processes a
lookup transformation configured to use the cache.

Recache from database: If the persistent cache is not
synchronized with he lookup table,U can configure the lookup
transformation to rebuild the lookup cache.

Static cache: U can configure a static or readonly cache for
only lookup table.By default informatica server creates a
static cache.It caches the lookup table and lookup values in
the cache for each row that comes into the
transformation.when the lookup condition is true,the
informatica server does not update the cache while it
prosesses the lookup transformation.

Dynamic cache: If u want to cache the target table and
insert new rows into cache and the target,u can create a
look up transformation to use dynamic cache.The informatica
server dynamically inerts data to the target table.

shared cache: U can share the lookup cache between multiple
transactions.U can share unnamed cache between
transformations inthe same maping.

Answer / rekha

Types are
STATIC CACHE : IT IS A READ ONLY CACHE USED FOR SINGLE
LOOK UP
DYNAMIC CACHE : USE THIS CACHE TO REFLECT THE CHANGED DATA
DIRECTLY ,WHEN THE TARGET TABLE IS LOOKUP
SHARED CACHE : THE CACHE USED AMONG MULTIPLE SESSIONS
PERSISTANT CACHE : THE CACHE USED AMONG MULTIPLE
TRANSFORMATIONS

Answer / satya

Types of lookup caches :
1.persistant cache
2.static cache
3.dynamic cache
4.shared cache

Answer / venkat

1)Static cache
2)Dynamic cache
3)Recache
4)Persistent cache
5)Reusable cache
6)Sequential cache
7) Concurrent cache
8)Shared cache

Answer / vaibhav

1)Persistent cache
2)Dynamic cache
3)Pre-build lookup cache
4)Shared Cache

Answer / 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 :)

Answer / surya

how we can identifiey the previous persistance cache?
can we use the persistance cache on another mapping?

what is the size of persistance cache?

advanced thanks for u r reply?
plz send the answer to mesuresh2007@gmail.com

Answer / ram

1. Full Cache
2. Part Cache
3. No Cache

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

need for registering a repository server

1 Answers  

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

why do u use shortcuts in informatica.?

4 Answers   iFlex,

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

How will you update the row without using update statergy?

10 Answers   CTS,