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

wf dont have integration severances how you can run?

0 Answers   TCS,


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  


why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,


I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,






Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  


without update strategy how to insert &update?

1 Answers   DELL,


How to Create a folder using pmrep command?

0 Answers  


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


Can you use flat files in Mapplets.

0 Answers  


Categories