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.
I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I …
ssas mdx data-warehouse olap ssas-2008I am new to SSIS in data warehouse. I am using Microsoft business intelligence studio. I have 5 Dimensions each having …
sql-server-2008 ssis data-warehouse factI'm getting my first exposure to data warehousing, and I’m wondering is it necessary to have foreign key constraints …
sql-server database-design data-warehouseLooks like my data warehouse project is moving to Teradata next year (from SQL Server 2005). I'm looking for resources about …
sql data-warehouse teradataBackground: I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP. I need to extract data from it …
postgresql data-warehouse etl near-real-time data-extractionI have a very complex Oracle view based on other materialized views, regular views as well as some tables (I …
oracle data-warehouse partitioning materialized-viewsI am building an analytics database (I have a firm understanding of the data and the business objectives and only …
database-design postgresql data-warehouse rails-postgresqlI am trying to build a data mart. I have lot of dimensions, and couple of measures - facts. Every …
database-design data-warehouse business-intelligence extensibility fact-tableI am a newcomer to data warehouses and have what I hope is an easy question about building a star …
data-warehouse olap olap-cube star-schemaWhen modeling a data warehouse, is there any reason we should favor Data Vault over Dimensional modelling? What are the …
database-design data-modeling data-warehouse data-vault