Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in data-warehouse

What if your fact has multiple instances of the dimension?

What are the differences between Amazon Redshift and the new AWS Glue datawarehousing services?

Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling

Weekly summary table; how to reference the time dimension

sql data-warehouse

Dimensional modeling on columnar databases

What's the difference between ETL and ELT?

creating dimension surrogate keys

How to populate fact table with Surrogate keys from dimensions

Best approach to implement inheritance in a data warehouse based on a postgres database

How do I fill null columns with values from the previous row?

Deleting rows from the destination that have been deleted from the source SSIS using Conditional Split

How can a multi-valued dimension be expressed in a star-schema given that it has 1-to-many relationship [Dim 1: many Fact]?

Data warehouse schema: is it OK to directly link fact tables in DWH?

data-warehouse

What is ODS role?

SSIS : Using a variable as the name of a flat file destination

What to name column in database table that holds versioning number

Microsoft Azure Data warehouse and SqlAlchemy

How to handle multitenant data warehouse (each customer has a unique schema)?

data-warehouse

Star schema [fact 1:n dimension]...how?

Adding/Combining Standard Deviations