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
- 8297 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 do you understand by ‘ibm predictive maintenance and quality’?
what is the difference between list report and crosstab report?
Diff b/w Crossproduct and Outerjoin?
Why is auto-regression used in forecasting used on cognos platform?
What is set to be Cognos configuration?
What is set to be cardinality?
what are the names of the reports that you prepared?
what are the filters in framework manager and report studio?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What are the services provided in cognos 8?
What is the use of powerhouse?
WHAT ARE THE DISTNICT VARIABLES?
can we insert all types of charts in a list report? what r the realtime prompts?
--------------Explain Table of contents?
