What are the types of lookup caches?
Answer Posted / 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 |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is target designer and target load order?
How are indexes created after completing the load process?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Why update strategy and union transformations are active?
How many ways a relational source definition can be updated and what are they?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between a connected look up and unconnected lookup?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Repository user profiles
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is the -ve test case in your project.
What do you mean by worklet?
What is a filter transformation and why it is an active one?
How can you differentiate between powercenter and power map?