Interested to Buy Any Domain ? << Click Here >> for more details...
what is materialised view? why we use it in data warehousing?
- 5 Answers
- 10215 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / c.venkataramana gupta
->Meterialized view is DBA object
-> to create meterializd view need dba perimission(previlege)
->it holds the static data (changes on table will not reflected on view)
-> at time of creating the data is stored in meterialized view, when ever another new record is not restricted.
-> no dml operations allowed
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / suman palisetty
Materialized Views are objects which have information that has been aggregated and summarized from source tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
MT views is a table which occupies space when ever we update it doesn't update in parent table we need to write a command to refersh the data in to parent table
Mainly used for Pre-aggregated Calculations....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram
Materialised view will stores the results of sql in the tables form in the database. materialised view contains data physically.view doesn't contain data physically.materialised view will be updated with batch upted know as refreshes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manoj
Materialized view contains special cache to store the data
and structure of the table.
it improves the perrformance becuase when we write the
query every time data is not feched from the base table
i.e. we will use in Datawarehouse.
| Is This Answer Correct ? | 0 Yes | 2 No |
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what are diff b/w cognos and business objects
how can i test the reports in cognos
What is difference between drill through and drill down?
What is the difference between low affinity and high affinity connections?
What is the basic relationship between measures and dimensions in transformer modelling
how many types of keys are there i.e primary key and foreign key etc..?
what is a join? what are the types of joins?
how to create cubes in transformer ?
Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance
Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.
How do we convert from Numeric to be Words?
Teradata 
