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 are the data types present in bo?
Explain a mapping, session, worklet, workflow, mapplet?
What is surrogate key? Where we use it?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is the difference between aggregate table and materialized view?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
How to export mappings to the production environment?
What are the various methods of getting incremental records or delta records from the source systems?
Suppose we want to display zero when null values coming to report how can we do that?
What is data analytics in simple terms?
How to reduce warnings?
What is the advantages data mining over traditional approaches?
Explain what are the advantages of query studio compared to report studio?
What is called data cleaning?
Difference between PowerPlay transformer and power play reports?
