1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answer Posted / sreenu
Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.
Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the various types of transformation?
What is the need of an ETL tool?
Partition, what happens if the specified key range is shorter and longer
What are the types of schemas we have in data warehouse.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are multi-group transformations?
What is fact table? Explain the different kinds of facts.
What are the databases that informatica can connect to windows?
How to configure mapping in informatica?
How can a transformation be made reusable?
How identifying bottlenecks in various components of informatica and resolving them?
Explain Dataware house architecture .how data flow from intial to end?
What is informatica? Why do we need it?
Mention few advantages of router transformation over filter transformation.
What is the difference between a connected look up and unconnected lookup?