Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56151 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
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 -ve test case in your project.
What is joiner transformation in informatica?
State the differences between sql override and lookup override?
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
What is main use of mapplet?
what is unit testing?tell me proceedure
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is meant by incremental aggregation?
What is meant by query override?
What are the transformations that are not supported in mapplet?
How do you load unique records into one target table and duplicate records into a different target table?
Differentiate between sessions and batches?
What is the meaning of decode in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the need of etl tools?
