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 your spectra photometer working principles?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are the different methods of loading dimension tables?
Explain what does level of granularity of a fact table signify?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain multivalued dependency?
What is the difference between ods and oltp?
Compare aggregates and data marts
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is the difference between drill through and masterdetail reports?
What are the different types of scd's used in data warehousing?
Where the applications and where ware house management system is used?
Explain a relation schema and a relation?
