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 |
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
How you load distinct records into one target and duplicate records into another target?
Types of error logs in Informatica?
can you use flat file for lookup table?why?
How many number of sessions can one group in batches?
what is the size of ur database(like oracle)
what are types of dimentions?
What are the popular informatica products?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Mention few advantages of router transformation over filter transformation.
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
can we generate reports in informatica ? How?