What is a fact table?
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 situations where snow flake schema is better than star schema to use and when the opposite is true?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What are diagrams?
0 Answers InfoAxon Technologies,
why oracle is the best database for data warehousing?
What is hash partition?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the steps involved in creating dimensional modeling process?
Explain functional dependency?
5.Explain ODS ?
What are the types of partitioning?
Tell me what is full load & incremental or refresh load?