Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialized view?
- 2 Answers
- 5048 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 |
In operator is used in which transformation in informatica 8.6.0
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
Can we update a target table (without primarykey) by using update strategy transformation?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
What is joiner transformation?
How do you load first and last records into target table?
What is the difference between bitmap and btree index?
What is sql query override? When did u use sql query override?
Explain target update override in informatica
Why we use stored procedure transformation?
Make a note of the quantity vaults made in informatica?
How can you validate all mappings in the repository simultaneously?
Teradata 
