Why Star Schema is de-normalized? Please explain in detail
probably with some examples.
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 are query items?
What are the roles defined by cognos platform?
What are all the advantages of Cognos?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
what are the dimensions that you have in your current project?list them?
Cleared COG-112 with 100% score today. What next certification should i go for?
Explain the characteristics of cognos?
What is meant by junk dimension?
What are all the types of indexes in Cognos?
What r the names of the reports that you prepared?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is Additive function?
What is a dimension?
how to perform single sign in cognos by using url?