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
Can any one explain the hierarchies level data warehousing.
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Suggest a good author for hyperion in data warehousing?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
How are models actually derived?
How to define a cube??
What are the stages that are required in data warehousing?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What are Non-additive facts?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain degenerate dimension table?
What are diagrams?
what are the different views that are considered when building an object-oriented software system?
What is the data type of the surrogate key?
