Answer Posted / vensh
Dimension table is nothing but a table which contains detailed description about the data except any values...
Fact table mainly contains the facts nothing but the values that is related to the data in the dimension table and by using the primary key in dimension table and the foreign key in the fact table we will map the dimensional table and the fact table
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
How to load the time dimension?
How can you communicate with web server (apache or iis) from coldfusion?
Explain the main differences between star and snowflake schema?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What is the difference between data warehouse and operational systems?
explain about balanced dimension,
Explain Association algorithm in Data mining?
How can we run the graph? What is the procedure for that?
Explain dimensional modelling?
What is the use of dimensional modeling in data warehousing?
Why is business intelligence (bi) important in data warehousing?
The same tier?
Explain bus schema?
Explain swot analysis?
Tell me what is full load & incremental or refresh load?