Interested to Buy Any Domain ? << Click Here >> for more details...
Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
- 2 Answers
- 8257 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / kumar
Star Schema is centally Located by Fact Table surrounded by
Dimension Tables, hence it resembles Star so we call it
as "Star Schema"
Here We use the De-Normalized tables, If we use Normalizewd
tables that prefer the Snow-Flake Schema.
In Star Schema we have the less no. of tables, so we have
the duplicate records with non key attributes.
For further Reference, Please go through the below URL.
http://datawarehouse4u.info/Data-warehouse-schema-
architecture-star-schema.html
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What r the names of the reports that you prepared?
What are cognos connection initial page components?
Can you define a datastore in cognos?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
what is a prompt value in report studio and variables ?
How to apply securities for reports in cognos connection?
What is Bitmap Index?
What is a Cube?
What are all the components of Report Studio?
What are the types of catalogs in cognos?
how u will determine the performence tune will occur either in report or system
What is the complex report you faced in real time?
5. Which type of report you build more, list, crosstab or chart and why?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
how to connect datamarts
