Answer Posted / srini madhala
Star Schema:In Star shema we have fact table sorrounded by
diemension table.Since the shape looks as a star its called
as star schema
Snow Flake Schema:
in Snow flake schema we have fact table sorrounded by
diemension table and the diemensional table have their child
diemensions.Its denormalized
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
Write types of folders present in cognos?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Define the slice and dice?
What do you understand by ‘ibm predictive maintenance and quality’?
What are the types of security?
How to Reset Pagenumbers in one report.
What are various types of gateways in cognos?
Explain the difference between powerplay transformer and power play reports?
How can create users and permissions in cognos?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
How can I test reports in cagonos?