Blog

Data Warehouse Engineering and Technology

greenplum

Catalog Corruption in Greenplum DB

by CK Tan

Recently one of our clients experienced catalog corruption in Greenplum DB after a power outage.

Read more...

postgres sql

Comparing Tables in Postgres

by CK Tan

How to tell if two tables are exactly the same?

Read more...

data warehouse

Date Dimension Table in Postgres

by CK Tan

One of the first dimension tables required for any Data Warehouse project is the Date Dimension table. See Calendar Date Dimensions @kimballgroup.

Read more...