Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in data-warehouse

columnar database

How to avoid joins between fact tables in a star schema?

snowflake is better than indexing?

Export Google Analytics data (log of events)

Talk to data warehouse-style tables with ActiveRecord?

How to handle late arriving dimension and NULL business key in Kimball Data Mart?

Merging tables with duplicate data

Dimensional Modelling

'SQL1024N A database connection does not exist. SQLSTATE=08003' error while executing 'db2 -x' command through command stage in Datastage 9.1

data-warehouse datastage

ETL options with Postgres [closed]

How should data be provided to a web server using a data warehouse?

sql web sftp data-warehouse

Naming standards for dimensional modeling

Is facts table in dimensional model is actually a table of events?

4-5-4 National Retail foundation Calendar csv download or function to create

sql calendar data-warehouse

can´t make referenced relationship to work

Managing very large SQL queries

sql oracle data-warehouse

Impute via fill-forward/LOCF a column over a range of sequential rows in SQL?

Handling Big Data in a Datawarehouse [closed]

Extrapolate daily historical values from a table that only records when a value changes (Postgresql 9.3)

MERGE - conditional "WHEN MATCHED THEN UPDATE"