Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25580 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
wf dont have integration severances how you can run?
What is dimensional table? Explain the different dimensions.
What does role playing dimension mean?
What is informatica worklet?
Explain pmcmd command usage in informatica
Why update strategy and union transformations are active? Explain with examples.
Please let me know how to make Data masking in informatica..
how we can load rejected record's at run time?(not through bad files)
what is Active lock explain
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
tell me the rules and responsblites in our project(my project is development)
What is source qualifier transformation in informatica?
what is size of u r database?
Explain the different lookup methods used in informatica?
How can one identify whether mapping is correct or not without connecting session?
