What are the Differences between static cache and dynamic cache?
Answer Posted / swetha
Static cache
Dynamic cache
U can not inert or update the cache. yoU
can insert rows into the cache as u pass
to the target
The informatic server returns a value from The
informatic server inserts rows into cache
the lookup table opr cache when the condition when the
condition is false.This indicates that
is true. When the condition is not true, the
the row is not in the cache or target table.
informatica server returns the default value yoU
can pass these rows to the target table.
for connected transformations and null for
unconnected transformations.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How can you define user defied event?
What is the maplet?
What is the session task and command task?
Define update strategy?
What is the status code in stored procedure transformation?
Tell me about Propagate functions in informatica
Different qualification between a related rotate toward the sky and isolates look upward?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the need of etl tools?
What is the difference between source qualifier transformations source filter to filter transformation?
What do you mean by worklet?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How can we use mapping variables in informatica? Where do we use them?
What is data caches/ index caches?