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
Explain the shared cache and re-cache?
What are the modules in Power Center
what are the Methods For Creating Reusable Transformations?
In warehouses how many schemas are there?
How can we remove the duplicates from flat file source?
What does refresh system mean, and what are its distinctive choice?
How do you migrate data from one environment to another?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How many numbers of sessions can one group in batches?
Mention few power centre client applications with their basic purpose?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the tasks that can be performed using sq?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
explain one complex mapping with logic? sales project?
Explain incremental aggregation in informatica
