what is shared Cache. when we will use shared Cache?
Answer Posted / 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 |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the commit type if you have a transaction control transformation in the mapping?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Performance tuning( what you did in performance tuning)
What is a grid in Informatica?
What are the limitations of joiner transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
how to load dimension table and fact table. plz tell me the steps.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
can we override a native sql query within informatica? How do we do it?
How we can create indexes after completing the load process?
What is Index Caches size?
What is confirmed fact in dataware housing?
What are the main issues while working with flat files as source and as targets ?