Whatis the difference between View and Materialized View ?
Answer Posted / harshakore
A view has a logical existence but a materialized view has
a physical existence.Moreover a materialized view can be
indexed,analysed and so on....that is all the things that
we can do with a table can also be done with a materialized
view.
| Is This Answer Correct ? | 110 Yes | 5 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
whats the logic to load the lower level of granularity of data to fact table.
Name the different lookup cache(s)?
what are 3 tech challenges/ common issues you face?
What are the static cache and dynamic cache in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
how to create user defined function (udf) in informatica
Define filter transformation?
explain one complex mapping with logic? sales project?
What are mapplets?
What are the designer tools for creating transformations?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Which version configuration tool used in ur project?