what is the difference between static and dynamic
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
in reporting we add some new objects,how we get the count of the newly added objects to the report
Do you find any difficulty while working with flat files as source and target?
What is exclusive and normal mode for repository services?
How many types of sessions are there in informatica.please explain them?
Explain the tuning lookup transformation - informatica
Explain load alternative records / rows into multiple targets - informatica
Plz can any one say me how to get the informatica certification materials and dumps
what is the difference between informatica6.1 and infomatica7.1
How can we create index after completion of load process?
can we override a native sql query within informatica? How do we do it?
What is the function of look up transformation?
list out all the transformations which use cache?
what is the size of your data warehousing?
What are mapplets?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?