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
What are the steps involved in the migration from older version to newer version of Informatica Server?
Define mapping and session?
How to Create a folder using pmrep command?
What are the mapping parameters and mapping variables?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
whats the logic to load the lower level of granularity of data to fact table.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Target increases every day even though no new record was inserted
What are connected or unconnected transformations?
How many ways are there to create ports?
What is the sequence generator transformation in informatica?
Briefly explain the aggregator transformation?
can anyone suggest best free Talend data integration training online
How to use pmcmd utility command?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.