Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15211 Views
- I also Faced
- E-Mail Answers
Answer Posted / pratap gangula
STAR Schema is a design that has a collection of one fact table and many dimension tables. Fact tables have the foreign keys to all the dimension tables and also keeps the additive measures for analysis. Dimension tables have the information needed to describe the measures in the fact. Basically dimensions are entities with all the attributes in a denormalized form.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is metadata in context of a datawarehouse?
What is a real-time data warehouse?
Can you pass sql queries in filter transformation?
What are session timeout and application timeout?
What are the data marts?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
How to export mappings to the production environment?
Explain how many ways you create ports?
What are fundamental stages of data warehousing?
How to drill through from a powerplay cube to reportnet?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what is cost benefit analysis (cba)?
Code the tables statement for a single-level (most common) frequency?
What are the data types present in bo?
