what is materialized view?
- 2 Answers
- 4223 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 |
What is the fact table?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What are the settings that you use to configure the joiner transformation?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
What is the need for an etl tool?
What are the two modes of datamovement in informatica sever?
can you use flat file for repository?why?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
How can you access the remote source into your session?
Enlist few areas or real-time situations where informatica is required.
in which situations do u go for scds ?
Teradata 
