How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.

Answer Posted / abhishek.x.upadhyay

A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

difference between repository database and repository service?

625


State the differences between sql override and lookup override?

623


How can we store previous session logs?

569


Describe expression transformation?

636


How do you use reject loader.

2071






what is the hint? how to use it to reduce the query processing in program?

6314


Is it possible to define a single node as a Gateway node as well as worker node?

660


What is transformation?

659


What is event and what are the tasks related to it?

616


What is resilience time?

655


Scheduling properties,whats the default (sequential)

1468


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

712


how to load dimension table and fact table. plz tell me the steps.

1685


Explain the mapping variable usage example in informatica

635


What are the informatica performance improvement tips

617