what is materialised view? why we use it in data warehousing?
- 5 Answers
- 8615 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 |
how you migrate reports to cognos 8 from previous versions?
What will happen if scheduling a report with a prompt page?
Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?
why we r using report studio in webbased only and fm windows based only
What is the advantage of using shortcuts?
8. Can you use calculations in report headers and footers? How?
Is it possible to join multiple Databases in a Catalog?
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
What are user classes?
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.
What is the deployment requirements used in cognos?
Teradata 
