how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / amit
when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What is sequence generator transformation in informatica?
What are the differences between oltp and olap?
Define enterprise data warehousing?
What is mapping debugger?
What is a node in Informatica?
What do you mean incremental aggregation?
What is an unconnected transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is data transformation manager process?
What is Index Caches size?
Explain sessions?
Can u generate reports in Informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
Parameter and variable differences
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?