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
difference between repository database and repository service?
State the differences between sql override and lookup override?
How can we store previous session logs?
Describe expression transformation?
How do you use reject loader.
what is the hint? how to use it to reduce the query processing in program?
Is it possible to define a single node as a Gateway node as well as worker node?
What is transformation?
What is event and what are the tasks related to it?
What is resilience time?
Scheduling properties,whats the default (sequential)
Which is the t/r that builts only single cache memory?
how to load dimension table and fact table. plz tell me the steps.
Explain the mapping variable usage example in informatica
What are the informatica performance improvement tips