Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialized view?
- 2 Answers
- 5193 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 |
How to extract the informatica rejected data?
What are the tasks that can be performed using sq?
What is the benefit of session partitioning?
Design a mapping to get year of join for each employee.
What is data transformation manager process?
What are limitations of joiner transformation?
What are the differences between oltp and olap?
How do you remove duplicate records in informatica?
what is upstream and downstream transformation?
What is the use of incremental aggregation?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Teradata 
