What r the types of lookup caches?

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.

  • Interview Candidate
  • 11
  • 28068

Showing Answers 1 - 11 of 11 Answers

Sithu

  • Dec 13th, 2005
 

Cache

1. Static cache

2. Dynamic cache

3. Persistent cache

Sithu

  Was this answer useful?  Yes

ravi

  • Mar 1st, 2006
 

Dynamic cache

Persistence Cache

Re cache

Shared Cache

  Was this answer useful?  Yes

Infoseek

  • Jan 5th, 2007
 

hi could any one get me information where you would use these caches for look ups and how do you set them.

thanks,

infoseeker

  Was this answer useful?  Yes

Stephen Ross

  • Apr 30th, 2007
 

There are 4 types of lookup cache -
Persistent, Recache, Satic & Dynamic.

Bye
Stephen

  Was this answer useful?  Yes

siraj.khan

  • Aug 3rd, 2007
 

Types of Caches are :

1) Dynamic Cache
2) Static Cache
3) Persistent Cache
4) Shared Cache
5) Unshared Cache

  Was this answer useful?  Yes

kathir

  • Aug 22nd, 2007
 

There are five types of caches such as
static cache,
dynamic cache,
persistant cache,
shared cache, etc...

  Was this answer useful?  Yes

Mattock

  • Sep 7th, 2011
 

Caches are of following types:
1. Static Cache
2. Dynamic Cache
3. Persistent Cache
4. Non-persistent Cache
5. Shared Cache
6. Un-shared Cache

More types to follow...:-)

  Was this answer useful?  Yes

adhoc

  • Sep 13th, 2011
 

There are 2 important caches.
1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row comes into the transformation it caches lookup table and look up values. it doesn't update the chache.
2. Dynamic cache: data will be inserted dynamically to the look up cache as well as target table.
other types of caches are Persistaent, Shared and Rechace.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions