Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of lookup caches?
- 10 Answers
- 69424 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
How many dimensions are there in informatica?
How to partition the Session?
Why is sorter an active transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is joiner transformation in informatica?
What are active transformations.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is rank transform?
Define mapping and session?
how to load dimension table and fact table. plz tell me the steps.
What is the need of etl tools?
In informatics server which files are created during the session rums?
Enlist few areas or real-time situations where informatica is required.
What are the restrictions of union transformation?
Write the program through which the records can be updated?
