Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25694 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / deepthi
static cache:
1.static cache remains same during the session run
2.static can be used to relational and falt file lookup
types
3.static cache can be used to both unconnected and
connected lookup transformation
4.we can handle multiple matches in static cache
5.we can use other than relational operators like <,>,<=,>=
&=
Dynamic cache:
1.dynamic cache changes durig session run
2.dynamic cache can be used to only relational lookup types
3.Dynamic cache can be used to only connetced lookups
4.we cannot multiple matches in dynamic cache
5.we can use only = operator with dynamic cache.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
What is a surrogate key?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the difference between a connected look up and unconnected lookup?
What are the features of complex mapping?
How to call shell scripts from informatica?
How we can use union transformation?
What is the reusable transformation?
What is blocking transformation?
What is dynamic cache?
How to use pmcmd utility command?
Explain lookup transformation source types in informatica
How to convert multiple rows to single row (multiple columns) in informatica
What is informatica powercenter repository?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
