how u know when to use a static cache and dynamic cache in
lookup transformation.

Answer Posted / abhsihek

Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Could you explain what is enterprise data warehouse?

543


how tokens will generate?

1719


Is there any target staging area in informatica not staging area

2112


Differentiate between a repository server and a powerhouse?

561


What is a predefined event?

647






What is the commit type if you have a transaction control transformation in the mapping?

639


Where are the source flat files kept before running the session?

608


What is confirmed fact in dataware housing?

5645


What does command task mean?

597


What do think which one is the better joiner or look up?

705


How might one distinguish in the case of mapping is right or not without associating session?

626


What is target load order?

790


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1901


According to his methodology what all you need before you build a datawarehouse

1174


What is a joiner transformation and why it is an active one?

562