Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialized view?
- 2 Answers
- 5319 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 |
Mention few power centre client applications with their basic purpose?
Different sorts of metadata that stores in the storage facility?
How does the session recovery work.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
How will you check the bottle necks in informatica? From where do you start checking?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
What are the different types of transformation available in informatica.
What are the different versions of informatica?
Explain the different dimensions.
How can we integrate different flat file data in a single mapping and with in a single execution
How to read data from flat file source if the data is in paragraph format?
what is left outer join?
Teradata 
