Interested to Buy Any Domain ? << Click Here >> for more details...
How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
- 2 Answers
- 7757 Views
- TCS, I also Faced
- E-Mail Answers
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
Design time, run time. If you don't create parameter what will happen
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Differentiate between a database and data warehouse?
What are the different types of transformation available in informatica.
What is the need for an etl tool?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Define the various join types of joiner transformation?
What is rank transformation in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
my source is junk data how will u remove that junk data by using unix please any one replay me
what is informatica metadata?
Design a mapping to load a target table with the following values from the above source?
Explain the difference between a data warehouse and a data mart?
Mention a few design and development best practices for informatica?
