How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
Answers were Sorted based on User's Feedback
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 |
Answer / qamar
I suppose the answer to this question is by using Joiner
transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
how to remove staging area
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
what is threshold error in informatica?
Mention few advantages of router transformation over filter transformation.
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
How to convert flat file into xml file? How to tune joiner?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
difference between informatica 8.1.1 and 8.6
how to run 2 workflows sequentially. plz respond what is the process?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
what is the difference between informatica6.1 and infomatica7.1
What is the procedure for creating independent data marts from informatica 7.1?