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 sorter transformation?
can we override a native sql query within informatica? How do we do it?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a repository? And how to add it in an informatica client?
pmscmd startworkflow -sv
What is pmcmd command?
define galaxy repository in informatica
What does command task mean?
What are the differences between oltp and olap?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are junk dimensions?
What is the use of transformation?
What is a joiner transformation?
Design a mapping to load a target table with the following values from the above source?
What are the prerequisite tasks to achieve the session partition?