Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in data-warehouse

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?

Data mart vs cubes

Surrogate Keys in Datawarehouse

Corrupted database table with invalid query: what has it done and will it roll back?

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

How are OLAP, OLTP, data warehouses, analytics, analysis and data mining related?

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

Adding/Combining Standard Deviations