Postgresql, Redshift, Etl, Transformation, Data Warehouse.
prescribed by ISO-8601. Both of these dimensions will be pre-filled with data. For ensuring that all the source tables can use these dimension tables with a simple JOIN, we need to ensure that we have temporal data types in these formats. For this too, we will create a couple of pgplsql functions.