Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56786 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
How can a transformation be made reusable?
What is the function of look up transformation?
Explain lookup transformation source types in informatica
How to extract sap data using informatica? What is abap? What are idocs?
Define joiner transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How can repository reports be accessed without sql or other transformations?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain load alternative records / rows into multiple targets - informatica
What is the difference between stop and abort in informatica
How can you generate reports in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the reusable transformation?
Explain the types of transformations?
