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
What if your fact has multiple instances of the dimension?
Oct 30, 2025
sql
data-warehouse
star-schema
What are the differences between Amazon Redshift and the new AWS Glue datawarehousing services?
Oct 28, 2025
amazon-web-services
cloud
data-warehouse
Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling
Oct 25, 2025
database
data-warehouse
dimension
dimensional-modeling
kimball
Weekly summary table; how to reference the time dimension
Oct 24, 2025
sql
data-warehouse
Dimensional modeling on columnar databases
Oct 25, 2025
reporting
data-modeling
data-warehouse
olap
dimensional-modeling
What's the difference between ETL and ELT?
Oct 23, 2025
bigdata
azure-databricks
data-warehouse
creating dimension surrogate keys
Oct 23, 2025
data-warehouse
dimensional-modeling
surrogate-key
How to populate fact table with Surrogate keys from dimensions
Oct 21, 2025
data-warehouse
dimensions
star-schema
surrogate-key
Best approach to implement inheritance in a data warehouse based on a postgres database
Oct 20, 2025
postgresql
database-design
data-warehouse
class-table-inheritance
multi-table-inheritance
How do I fill null columns with values from the previous row?
Oct 14, 2025
sql
google-bigquery
left-join
data-warehouse
gaps-and-islands
Deleting rows from the destination that have been deleted from the source SSIS using Conditional Split
Sep 21, 2025
sql-server
ssis
data-warehouse
How can a multi-valued dimension be expressed in a star-schema given that it has 1-to-many relationship [Dim 1: many Fact]?
Sep 09, 2025
data-warehouse
business-intelligence
star-schema
Data warehouse schema: is it OK to directly link fact tables in DWH?
Sep 07, 2025
data-warehouse
What is ODS role?
Sep 06, 2025
database
data-modeling
data-warehouse
SSIS : Using a variable as the name of a flat file destination
Mar 05, 2023
sql
sql-server
ssis
data-warehouse
What to name column in database table that holds versioning number
Mar 02, 2023
database-design
data-warehouse
columnname
Microsoft Azure Data warehouse and SqlAlchemy
Feb 07, 2023
python
python-2.7
azure
sqlalchemy
data-warehouse
How to handle multitenant data warehouse (each customer has a unique schema)?
Feb 07, 2023
data-warehouse
Star schema [fact 1:n dimension]...how?
Jan 24, 2023
data-warehouse
olap
olap-cube
star-schema
Adding/Combining Standard Deviations
Sep 02, 2025
database
math
data-warehouse
Older Entries »