Answer Posted / dipti a
Fact Table is the central table which has factual information. It contains numeric information and measures.
Lets say if you need to capture sales data then centrally we can have sales table(fact table) which contains numeric information and surrounding to it, we can have dimensions table like product dimensions, date dimensions, store dimensions.
So this central fact table will contacts numeric information like Prize_of_product, Qualntity and along with same we can have dimension foreign keys like product_id, store_id, date_id and so on.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain swot analysis?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain where do we use semi and non additive facts?
what are different storage options supported by oracle ?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Can we start and stop single session in concurent bstch?
Explain what are the advantages of query studio compared to report studio?
What is the difference between metadata and data dictionary?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
what are relationships?
What is aggregate fact table?
What is Operational Data Store?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is data stream and data adaopter?
What are the stages that are required in data warehousing?
