wt is Dynamic lookup Transformation?
when we use?how we use?
Answer Posted / padmavathi
What Ashis told is Exactly correct apart of this Actually
when lookup table contains less data then we will go for
the Dynamic Lookup cache, performance increases.If large
data is there means its better to go for static cache.
| Is This Answer Correct ? | 20 Yes | 6 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
What are the new features of Power Center 5.0?
How are indexes created after completing the load process?
Explain joiner transformation in informatica
Explain the mapping variable usage example in informatica
What is the function of aggregator transformation?
differences between service based and product based?
Can you use flat files in Mapplets.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Which version configuration tool used in ur project?
Explain the types of transformations?
Write the advantages of partitioning a session?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
generate date / time dimension in informatica
What is the difference between a connected look up and unconnected lookup?