Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is dimension modeling?
What are universe requirements?
Explain what is the difference between olap and datawarehosue?
Start a batches with in a batch?
in general which algorithms for used?
Explain hybrid slowly changing dimension?
How to pivot data using informatica when you have variable amount of pivot rows?
What are the key features of chameleon that separates it from other algorithms?
What are the different ways to represent the loading of dimension tables?
What are the key columns in Fact and dimension tables?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What are the different types of join operations?
What is incremintal loading?
What is difference between e-r modeling and dimensional modeling?
What is Cognos script editor?
