Top "Data-warehouse" questions

A data warehouse (DW) is a database specifically structured/designed to aid in querying, analyzing and reporting (generating reports out of) of current and historical data.

Difference between Fact table and Dimension table?

When reading a book for business objects, I came across the term- fact table and dimension table. I am trying …

database data-warehouse business-intelligence fact-table
What is the difference between a database and a data warehouse?

What is the difference between a database and a data warehouse? Aren't they the same thing, or at least written …

database data-warehouse
Database choice for large data volume?

I'm about to start a new project which should have a rather large database. The number of tables will not …

database data-warehouse evaluation
Data Warehouse vs. OLAP Cube?

Can anyone explain what is really distinction between Data Warehouse and OLAP Cubes? Are they different approach for same thing? …

data-warehouse olap olap-cube
What are the types of dimension tables in star schema design?

When reading about star schema design I have seen that many people uses various names for different types of dimension …

data-warehouse dimension dimensional-modeling star-schema
Datamart vs. reporting Cube, what are the differences?

The terms are used all over the place, and I don't know of crisp definitions. I'm pretty sure I know …

data-warehouse cubes datamart
What is the actual difference between Data Warehouse & Big Data?

I know what is Data Warehouse & what is Big Data. But I am confused with Data Warehouse Vs Big …

database bigdata data-warehouse
What are the open source tools and techniques to build a complete data warehouse platform?

I'm looking for these open source tools possibly free or with free trial version to set up complete data warehouse …

open-source data-warehouse
What's the difference between additive, semi-additive, and non-additive measures

I have searched in the net what's the difference between additive, semi-additive, and non-additive measures in a data warehouse. I …

data-warehouse business-intelligence
What are the differences between Data Lineage and Data Provenance?

From wiki, Data lineage is defined as a data life cycle that includes the data's origins and where it moves …

database data-warehouse