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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are connected or unconnected transformations?
Why update strategy and union transformations are active?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to open an older version of an object in the workspace?
What is the difference between informatica 7.0 and 8.0?
What are the differences between oltp and olap?
What is the use of target designer?
Briefly define reusable transformation?
What is decode in informatica?
How to handle decimal places while importing a flatfile into informatica?
How would you copy the content of one repository to another repository?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the different kinds of facts.