What are the types of lookup caches?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of olap? Give an example?
Explain the shared cache and re-cache?
Mention some types of transformation?
What is the cumulative sum and moving sum?
What do you mean by worklet?
Define joiner transformation?
How to generate sequence numbers without using the sequence generator transformation?
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
Write the advantages of partitioning a session?
As union transformation gives UNION ALL output, how you will get the UNION output?
What do you understand by term role-playing dimension?
What is Index Caches size?
Enlist the advantages of informatica.
How to create Target definition for flat files?
What is an expression transformation?