Interested to Buy Any Domain ? << Click Here >> for more details...
What is a fact table?
- 1 Answers
- 1634 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 are the different ways to represent the loading of dimension tables?
Explain piconet?
What is a relationship?
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Why null values are mapped as 0 in fact tables?
What is hash partition?
Where the data cube technology is used?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the working process for application.cfm?
What is difference macros and prompts?
Teradata 
