Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialized view?
- 2 Answers
- 5215 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shruthi
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / mike
Well in simple terms
A meterialized view is a view that contains data in some
temporary tables. If we consider the view at database level
it only stores the query , when ever we call the view it
extracts the data from the database based on the query...
| Is This Answer Correct ? | 0 Yes | 0 No |
Useful UNIX commands regular/frequently used
What is option by which we can run all the sessions in a batch simultaneously?
can we generate reports in informatica ? How?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
How many dimensions are there in informatica?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
performance wise which one is better in joiner and lookup transformation
How big was your fact table
What is session task and command task?
What is the query to find nth highest salary? What is the use of cursors?
list out all the transformations which use cache?
what is data driven?
Teradata 
