Interested to Buy Any Domain ? << Click Here >> for more details...
What snowflake and Starschema?
- 2 Answers
- 6179 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhaskar.nagi
Star Schema: Star Schema contains Centrally located Fact
table sourended by Dimension Tables. So Data Base design
looks like a Start. Fact table contains the fact information
at the lowest level granularity. Fact table contains Foreign
keys and Dimension Table contains Primary key.
Snow Flake Schema: In a star schema, if a dimension table is
spleted into one or more dimension results in normalization
of dimensions. Since the database design looks like snow
flake structure.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
16. How can we create top 10 and bottom 10 records in the same list?
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?
What do you mean by drill across?
What is Merging, Segments and porting in Framwork Manager?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem
Column level security in report
How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...
What is the diff between Drill through reports and Master detail reports?
what is the difference between enterprise data warehouse and data warehouse
What is catalog and types of catalogs in cagonos and which is better?
What is meant by junk dimension?
Teradata 
