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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is a joiner transformation and why it is an active one?
How to call shell scripts from informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is incremental aggregation?
Explain pushdown optimization and types in informatica
To import the flat file definition into the designer where should the flat file be placed?
Name the different lookup cache(s)?
What is the need of an ETL tool?
What is the command used to run a batch?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is joiner transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
