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 mapping parameter and variable works
What are the limitations of joiner transformation?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain pmcmd command usage in informatica
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What is meant by query override?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
Target increases every day even though no new record was inserted
What is the function of look up transformation?
Tell me about informatica architecture.
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..