Search code examples
PLSQL: Query star schema time-dimension without stored date...


sqloracle-databasedateplsqlstar-schema

Read More
How to create a data model for invoices in a large data warehouse?...


data-modelingdata-warehousestar-schema

Read More
multi links between Fact_Table & Date_Dimension...


data-warehousebusiness-intelligencedimensional-modelingstar-schemafact-table

Read More
Reporting tool for OLAP, *not* OLTP!...


.netreportingolap-cubestar-schemasnowflake-schema

Read More
Sample star schema dataset...


databasesamplestar-schema

Read More
Creating a data warehouse with SQL Server 2008 Enterprise...


sql-serveretldata-warehousedenormalizationstar-schema

Read More
Creating fact table with year of 9999...


oracle-databaseschemadata-warehousestar-schema

Read More
Dimensional modeling for waiting process...


sql-serverdatabase-designentity-relationshipdimensional-modelingstar-schema

Read More
How to solve this? Use a bridge table?...


sql-serverdata-warehousestar-schema

Read More
Should I flatten multiple customer into one row of dimension or using a bridge table...


data-warehousestar-schema

Read More
Customer Dimension as Fact Table in Star Schema...


ssasdata-warehousebusiness-intelligencedimensional-modelingstar-schema

Read More
What is a good web application SQL Server data mart implementation in ElasticSearch?...


sql-serverelasticsearchkibana-4star-schemadatamart

Read More
How to design an errors table for data validations in a star schema...


sql-serverdatabase-designstar-schema

Read More
Data warehousing more than one data type in a fact table...


ssmsdata-warehousestar-schema

Read More
What to do when daylight savings results in duplicate data rows?...


data-warehousedststar-schema

Read More
Difference between sql query aggregation and aggegration and querying an OLAP cube...


analyticsdata-warehouseolapolap-cubestar-schema

Read More
Handling change of grain for a snapshot fact table in a star-schema...


data-warehousestar-schema

Read More
Dimensional data warehouse customer with multiple accounts...


oracle-databasedata-warehousedimensional-modelingstar-schema

Read More
Hierarchies and levels (Pentaho schema workbench)?...


pentahokettlestar-schema

Read More
Designing a Data Warehouse/ Star Schema - Choosing facts...


data-warehousedimensional-modelingstar-schema

Read More
Star Schema Design for User Utilization Reports...


data-warehousestar-schemamicrostrategyfact-tablesnowflake-schema

Read More
Data Warehouse schema : Star or Snowflake (case included)...


sqldata-warehousessmsstar-schemasnowflake-schema

Read More
Is a snowflake schema better than a star schema for data mining?...


sqlschemadata-warehousestar-schemasnowflake-schema

Read More
hierarchical modeling data warehouse - snowflake or star?...


data-warehousemodelingstar-schemasnowflake-schema

Read More
Designing fact table to allow simple most-recent detection of classes of facts...


data-warehousestar-schema

Read More
Table A's PK is being referenced by Table B's FK. Cannot drop Table A's PK...


sqlsql-serverstar-schema

Read More
Why should we separate dimension and facts instead of combining both in one table...


data-warehousedimensional-modelingstar-schema

Read More
Complex processing in Stored procedures Vs .net application...


databaseperformancestored-proceduresstar-schema

Read More
Postgresql - window functions within window functions...


sqlpostgresqlwindow-functionsstar-schema

Read More
Fact table organization...


etldimensional-modelingstar-schema

Read More
BackNext