when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
Answer Posted / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
server hot-ws270 is connect to Repository B. What does it mean?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How you know when to use a static cache and dynamic cache in lookup transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the differences between oltp and olap?
Mention few power centre client applications with their basic purpose?
Define sessions in informatica etl?
What is a dimensional model?
What are batches?
What do you understand by term role-playing dimension?
What is a difference between complete, stop and abort?
What are active transformations.