how can we check whether a particular cache is static or
dynamic?
Answer / praveen n
Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static
Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen
| Is This Answer Correct ? | 20 Yes | 0 No |
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to recover the standalone session?
how to design mapping half of source table records into one target and remaining half into another target
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
In which scenario did you used pushdown optimization?
What r the type of indexes u generally used in informatica?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
Is it possible to have "5 source & 5 Target" in single mapping?
What are junk dimensions?
How to Create a folder using pmrep command?
what is the size of u r source(like file or table)?