What are the Differences between static cache and dynamic cache?



What are the Differences between static cache and dynamic cache?..

Answer / swetha

Static cache
Dynamic cache

U can not inert or update the cache. yoU
can insert rows into the cache as u pass


to the target

The informatic server returns a value from The
informatic server inserts rows into cache

the lookup table opr cache when the condition when the
condition is false.This indicates that

is true. When the condition is not true, the
the row is not in the cache or target table.

informatica server returns the default value yoU
can pass these rows to the target table.

for connected transformations and null for

unconnected transformations.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

Which kind of index is preferred in DWH?

2 Answers  


How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


what is the size of your data warehousing?

0 Answers   IBM,


how to get the only updated records in the target

2 Answers  


How to create the source and target database connections in server manager?

0 Answers   Informatica,


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,


Which is the t/r that builts only single cache memory?

0 Answers  


A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  


What is galaxy shema

2 Answers   CGI,


wat are deployement groups in informatica, how it will be used for developers

0 Answers  


What are the types of maping in Getting Started Wizard?

1 Answers  


Categories