Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / veni
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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
According to his methodology what all you need before you build a datawarehouse
Explain the aggregator transformation?
What does refresh system mean, and what are its distinctive choice?
Where can we find the throughput option in informatica?
What is a joiner transformation?
How do you promote a non-reusable transformation to reusable transformation?
Difference between Data and Index Caches?
What is target designer and target load order?
What do you mean by channel change?
Which means the first record should come as last record and last record should come as first record and load into the target file?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is joiner change?
What is meant by target load plan?
How can repository reports be accessed without sql or other transformations?
