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

Explain the different dimensions.

739


Differentiate between reusable transformation and mapplet.

854


What is dimensional table?

813


What is joiner change?

914


What is standalone command task?

1018


How does a sorter cache works?

795


lookup transformation with screenshots

3769


What is meant by lookup transformation? Explain the types of lookup transformation?

746


How does the aggregator transformation handle null values?

924


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2190


Which files are created during the session rums by informatics server?

929


What happens when a session fails and you click on recover?

864


How is union transformation utilized?

780


Separate from a database, an information bazaar, and an information stockroom?

833


What is an expression transformation in informatica?

762