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
Explain the different dimensions.
Differentiate between reusable transformation and mapplet.
What is dimensional table?
What is joiner change?
What is standalone command task?
How does a sorter cache works?
lookup transformation with screenshots
What is meant by lookup transformation? Explain the types of lookup transformation?
How does the aggregator transformation handle null values?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Which files are created during the session rums by informatics server?
What happens when a session fails and you click on recover?
How is union transformation utilized?
Separate from a database, an information bazaar, and an information stockroom?
What is an expression transformation in informatica?