Informatica - What r the types of lookup caches?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 46 of 631

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.

Total Answers and Comments: 7

Last Update: August 23, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 13, 2005 06:02:36

Sithu

RE: What r the types of lookup caches?

Cache

1. Static cache

2. Dynamic cache

3. Persistent cache

Sithu

Is this answer useful? Yes | No

January 04, 2006 05:48:41

sithusithu

Member Since: December 2005 Contribution: 161

RE: What r the types of lookup caches?


Cache are three types namely Dynamic cache, Static cache, Persistent cache Cheers, Sithu

Is this answer useful? Yes | No

March 01, 2006 02:16:06

ravi

RE: What r the types of lookup caches?

Dynamic cache

Persistence Cache

Re cache

Shared Cache

Is this answer useful? Yes | No

January 05, 2007 10:46:55

Infoseek

Member Since: January 2007 Contribution: 4

RE: What r the types of lookup caches?

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

thanks,

infoseeker

Is this answer useful? Yes | No

April 30, 2007 01:59:02

Stephen Ross

RE: What r the types of lookup caches?

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

Bye
Stephen

Is this answer useful? Yes | No

August 03, 2007 07:43:14

siraj.khan

RE: What r the types of lookup caches?

Types of Caches are :

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

Is this answer useful? Yes | No

August 22, 2007 11:33:25

kathir

RE: What r the types of lookup caches?

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

Is this answer useful? Yes | No

Go To Top