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
What are the main features of Oracle 8i with context to datawarehouse?
Why is sorter an active transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What is an unconnected transformation?
Why filter transformation is an active one?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the types of presistent cache in look up tr.
Sequence generator, when you move from develoment to production how will you reset
Define Pmrep command?
In informatics server which files are created during the session rums?
What is the need of etl tools?
EXL informatica Questions
What is meant by a domain?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?