Postgresql, Redshift, Etl, Transformation, Data Warehouse.
Standardizing data across the database for a Data Warehouse This is a short summary of how to use PostgreSQL functions to transform data from an OLTP application into something that is useful for an OLAP data warehouse — especially taking into consideration all the non-standard SQL data types