Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is difference between static cache and dynamic cache?




2670
views
asked SRVMTrainings December 18, 2011 06:10 AM  

What is difference between static cache and dynamic cache?


           

4 Answers



 
answered By SRVMTrainings   0  
Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition. Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. Can have any relational operator in lookup condition.
flag   
   add comment

 
answered By SRVMTrainings   0  
Static- 1.Once the data is cached , it will not change. example unconnected lookup uses static cache. 2. while using a static cache in lookup we can use all operators like =,... while giving condition in condition tab 3.It is readonly cache 4.Informatica returns value when condition is true and if it is false it will return default value in connected look up and Null value in unconnected look up Dynamic- 1.The cache is updated as to reflect the update in the table( or source) for which it is reffering to.(ex. connected lookup). 2.But in using dynamic cache we only can use = operator 3.It is Read and Write 4.It will return only if condition is false
flag   
   add comment

 
answered By SRVMTrainings   0  
Dynamic cache - can be configured as connected lookup only. It does not support lookup on flat file. Can have only equality operator in lookup condition. Static cache - can be configured as connected as well as unconnected lookup. Supports lookup on flatfile. Can have any relational operator in lookup condition.
flag   
   add comment

 
answered By SRVMTrainings   0  
Static Cache: 1.You can not insert or update the cache. 2.The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations. Dynamic Cache: 1.You can insert rows into the cache as u pass to the target 2.The informatic server inserts rows into cache when the condition is false.This indicates that the the row is not in the cache or target table. U can pass these rows to the target table
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert