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
What is a real-time data warehouse?
What are the tools available for etl?
Explain what is type 2 version dimension?
What is static and local variable?
How to know the time taken for particular report execution?
Is there any default username & pwd for bo designer & supervisor?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is metadata in context of a datawarehouse?
Why should you put your data warehouse on a different system than your oltp system?
What are steps we have to follow in designing the userfriendly universe?
what are the different views that are considered when building an object-oriented software system?
Explain what are the various reporting tools in the market?
How can we run the graph? How can we schedule the graph in unix?
What are the different types of join operations?
Describe a data warehouse.