what is shared Cache. when we will use shared Cache?
Answers were Sorted based on User's Feedback
Answer / rao
shared cache is a one of the lookup caches of a lookup
transformation.
if we choose this option Informatica server creates the
cache memory for multiple lookup transformations in the mapping.
when first lookup transformation function completed then
memory is released and use that memory used by the other
look up transformation.
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / matt
We are talking about shared vs split cache.
Split cache is when data and instructions are located in different locations in cache.
Shared cache is when data and instructions are located in the same area of cache.
Is split cache effective? It depends on the program, and how heavily it relies on the data vs the instructions...
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / srinu
shared is used for multiful t/r.if unnamed shared cache
used b/w t/r in same mapping.
named cache used b/w t/r in same and different mapping.
srinu
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pushparao
shared cache is used to store the all scheduled information
with in a session.
| Is This Answer Correct ? | 0 Yes | 10 No |
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
How we can create indexes after completing the loan process?
whats the logic to load the lower level of granularity of data to fact table.
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is Collect performance data in informatica and what is the use of it.
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
What is tracing level and what are the types of tracing level?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???