Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1609 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the function of etl when used in data warehousing?
What is the limit to the number of sources and targets you can have in a mapping?
What is power play plug in?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is the difference between star and snowflake schemas?
how much memory space occupied real time project (roughly)?
List down some of the real time data-warehousing tools?
What is batch processing?
What are universe requirements?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Briefly state different between data ware house & data mart?
What is an OLAP (On-line Analytical processing) system?
Teradata 
