Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in data-warehouse
Data mart vs cubes
Jan 20, 2023
ssis
ssas
data-warehouse
cube
datamart
Surrogate Keys in Datawarehouse
Jan 06, 2023
data-warehouse
business-intelligence
surrogate-key
Corrupted database table with invalid query: what has it done and will it roll back?
Dec 29, 2022
sql
sql-server
data-warehouse
How to create a data model for invoices in a large data warehouse?
Dec 28, 2022
data-modeling
data-warehouse
star-schema
How are OLAP, OLTP, data warehouses, analytics, analysis and data mining related?
Dec 26, 2022
database
analytics
data-warehouse
olap
oltp
Why should we separate dimension and facts instead of combining both in one table
Dec 27, 2022
data-warehouse
dimensional-modeling
star-schema
How do i add a column to a fact table 'after' it is already deployed and populated?
Dec 19, 2022
sql-server-2005
data-warehouse
business-intelligence
Free data warehousing systems--specifically, for data storage
Dec 10, 2022
data-warehouse
database
Cross reference Facts and Dimensions in Data warehouse
Nov 16, 2022
ssas
data-warehouse
business-intelligence
Type II SCD with entities that merge over time
Nov 14, 2022
data-warehouse
dimensional-modeling
scd
type-2-dimension
Downloadable example of a normalize Inmon Enterprise Data Warehouse
Nov 13, 2022
data-warehouse
Microsoft cubes usage boundaries and best practicies
Nov 09, 2022
sql-server
database-design
architecture
data-warehouse
cube
Data storage for financial analysis
Nov 07, 2022
database
data-warehouse
greenplum
infobright
monetdb
Refresh strategy for materialized views in a data warehouse
Nov 05, 2022
sql
performance
oracle
plsql
data-warehouse
columnar database
Nov 01, 2022
sql
sql-server
data-warehouse
database-performance
How to avoid joins between fact tables in a star schema?
Nov 01, 2022
database-design
data-warehouse
star-schema
snowflake is better than indexing?
Oct 24, 2022
database
performance
data-warehouse
snowflake-schema
Export Google Analytics data (log of events)
Oct 21, 2022
database
google-analytics
google-analytics-api
etl
data-warehouse
Extrapolate daily historical values from a table that only records when a value changes (Postgresql 9.3)
Jun 10, 2022
sql
postgresql
data-warehouse
postgresql-9.3
« Newer Entries
Older Entries »