how can we check whether a particular cache is static or
dynamic?
Answer Posted / 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 |
Post New Answer View All Answers
How do you handle two sessions in Informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain scd type 3 through mapping.
What is domain and gateway node?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the features of complex mapping?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is union transformation in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the types of caches in lookup? Explain them.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the mapping parameters and mapping variables?
what are the deliverables?in your project?