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 |
what are surrogate keys?
How many dimensions are there in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Make a note of the quantity vaults made in informatica?
what is the flow?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
in which situations do u go for sequence generator ?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
can we create index and drop index in exsisting table while using infomatica
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
what happens when a batch fails?