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

What are multi-group transformations?

649


While importing the relational source definition from the database, what are the metadata of source that will be imported?

907


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

821


What is the difference between STOP and ABORT options in Workflow Monitor?

801


How to create or import flat file definition in to the warehouse designer?

718






How do we call shell scripts from informatica?

665


Explain the types of lookup transformation?

690


which one is better performance wise joiner or look up

727


How can we handle two sessions in informatica?

691


What is dimensional table? Explain the different dimensions.

768


can u any challenge your project?

1696


r u done any partitions in ur project?

1475


What are connected or unconnected transformations?

721


How to partition the Session?

729


How to delete duplicate row using informatica?

697