Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of lookup caches?
- 10 Answers
- 69030 Views
- Accenture, IBM, Informatica, I also Faced
- E-Mail Answers
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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you mean incremental aggregation?
Is it possible to define a single node as a Gateway node as well as worker node?
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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is Cognos script editor?
How do we call shell scripts from informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
How do you convert single row from source into three rows into target?
draw informatica architecture 8.6 ?
What is joiner transformation in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a surrogate key?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to delete duplicate row using informatica?
