Explain difference between view and materialized view?
- 1 Answers
- 1054 Views
- I also Faced
- E-Mail Answers
Answer / Mahesh Kumar
"A view is a virtual table in a database that contains the result set of an SQL query. When a user accesses a view, the database executes the underlying query to retrieve the data. A materialized view, on the other hand, is a pre-computed and physically stored version of a view. This allows for faster query performance because the data does not need to be recomputed each time the view is accessed."
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of SCD?
What is the use of dimensional modeling in data warehousing?
What is difference between model & package?
difference between For each and for all
How can you define a transformation? What are different types of transformations in Informatica?
What is the "junk dimension"? Give with examples?
What are the fundamental elements of the data warehouse?
How do you define data block size?
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is defined as partial backup?
Explain which columns go to the fact table and which columns go the dimension table?
Teradata 
