what is the difference between static and dynamic
Answer Posted / nagaraju bhatraju
Uncached lookup: The informatica server doesnot build a
cache for temporary starage of data. Wenever it need to
refer to the look up table, it scans the source directly.
Dynamic Cache: The informaatica server builds a cache of
the source wen the workflow runs for the first time and it
updates the cache records dynamically after each row it
loads to the target. Means, if a target row gets updated,
the dynamic cache also gets updated automatically after
that particular row comitted in the target.
or
Dynamic cache - can be configured as connected lookup only.
It does not support lookup on flat file. Can have only
equality operator in lookup condition.
Static cache - can be configured as connected as well as
unconnected lookup. Supports lookup on flatfile. Can have
any relational operator in lookup condition.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Can we get 1st record through Informatica(without sequence number).
What is DR strategy for Informatica project?
Write the advantages of partitioning a session?
What is the difference between source qualifier transformations source filter to filter transformation?
Define joiner transformation?
What do think which one is the better joiner or look up?
What is the maplet?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is difference between a gateway node and worker node?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are roles and groups and benefits of using them?
What is sorter transformation?
How does the aggregator transformation handle null values?
What are data-driven sessions?
How to load last n records of file into target table - informatica