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

Answer Posted / 24/12/2007

if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you take back up of repository?

703


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9135


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1528


Under what condition selecting sorted input in aggregator may fail the session?

639


Explain your project of banking domian.

1194






Differentiate between joiner and lookup transformation?

591


Explain what is informatica metadata and where is it stored?

592


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

571


Can we create multiple integration service on single repository?

684


What is the need of an ETL tool?

616


What is meant by lookup transformation? Explain the types of lookup transformation?

545


can we override a native sql query within informatica? How do we do it?

624


Explain incremental aggregation in informatica

630


How do you promote a non-reusable transformation to reusable transformation?

641


Is it possible to revert a global repository to local one and why?

591