Interested to Buy Any Domain ? << Click Here >> for more details...
How do we implement materialized view?when to use materialized view?
- 1 Answers
- 7877 Views
- TCS, I also Faced
- E-Mail Answers
Answer / chanti
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.
A materialized view can be stored in the same database as its base table(s) or in a different database.
Materialized views stored in the same database as their base tables can improve query performance through query rewrites. Query rewrites are particularly useful in a data warehouse environment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Which transformation should we use to normalise the COBOL and relational sources?
what is the command to get the list of files in a directory in unix?
Explain Dataware house architecture .how data flow from intial to end?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
without update strategy how to insert &update?
How we can confirm all mappings in the repository simultaneously?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What is the difference between a table and the materialized view?
What is a rank transform?
How does the aggregator transformation handle null values?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is souce qualifier transformation it is active or passive
Teradata 
