Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56821 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / manohara reddy
view is logic and virtual table. it does't hold data.it
allows DML Operations.when ever u update or insert in base
table or view automatically changed those.
materialized view is static. u want create m.view DBA
Privileges and permissions must. it hold data all. when ever
u update or create rows in base table , it update only
update base table. doesn't change.
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
What are the tasks that can be performed using sq?
Explain the types of transformations?
What is union transformation in informatica?
What are the mapping parameters and mapping variables?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How you prepared reports for OLAP?
how to load dimension table and fact table. plz tell me the steps.
Write the program through which the records can be updated?
What is a standalone command task?
Explain in detail about scd type 1 through mapping.
How can we update a record in the target table without using update strategy?
how we can load rejected record's at run time?(not through bad files)
How can informatica be used for an organization?
What is the command used to run a batch?
