What are the types of lookup caches?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 63 Yes | 4 No |
Answer / yallu
Types of lookup caches :
1.persistant cache
2.static cache
3.dynamic cache
4.shared cache
5.recache from source
| Is This Answer Correct ? | 31 Yes | 0 No |
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.
| Is This Answer Correct ? | 16 Yes | 3 No |
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
| Is This Answer Correct ? | 19 Yes | 11 No |
Answer / satya
Types of lookup caches :
1.persistant cache
2.static cache
3.dynamic cache
4.shared cache
| Is This Answer Correct ? | 13 Yes | 7 No |
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
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / vaibhav
1)Persistent cache
2)Dynamic cache
3)Pre-build lookup cache
4)Shared Cache
| Is This Answer Correct ? | 1 Yes | 0 No |
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 :)
| Is This Answer Correct ? | 1 Yes | 1 No |
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
| Is This Answer Correct ? | 2 Yes | 10 No |
Explain in detail scd type 2 through mapping.
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
What is Performance tuning in Informatica?
Explain the mapping variable usage example in informatica
how do u use sequence created in oracle in informatica? Explain with an simple example
What is the session task and command task?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How to extract sap data using informatica? What is abap? What are idocs?
What is confirmed dimension with scenario
How to recover the standalone session?
What is a difference between complete, stop and abort?
What is the default join that source qualifier provides?