Track source dates when loading a data warehouse
A primer on how to reduce network and source system load when reading a relational source into the data warehouse.
2012-07-30
5,000 reads
A primer on how to reduce network and source system load when reading a relational source into the data warehouse.
2012-07-30
5,000 reads
Data warehouse loads can be time consuming - this method can be used in some instances to help speed things up.
2010-04-14
16,447 reads
Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, […]
2005-06-07
438 reads
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
I have response from a API that look like { "responseCode": 200, "message": "success",...
I have response from a API that look like { "responseCode": 200, "message": "success",...
So here's a thing that I've been told several times over the past few...