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

What is the function of union transformation?

872


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1889


Which development components of informatica have the highest usage?

829


Explain in detail about scd type 1 through mapping.

861


While migrating the data from one environment to another environment how would you manage the connections?

901


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

948


What is a code page?

931


How union transformation is used?

805


scenario where i can use only concurrent execution of workflow.

2815


Design time, run time. If you don't create parameter what will happen

1644


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1266


Explain what is informatica metadata and where is it stored?

845


What do you understand by a term domain?

893


Repository user profiles

1583


How will the document be delivered to me?

847