Tag: Data warehouse
-
A T-SQL SPLIT function
When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom the case and recently I was faced with the problem that single field contained a rather dirty list. First I cleaned the list using REPLACE to replace the variety of delimiters with comma. Then I…
-
How to create a calendar table with hourly grain
Calendar Tables – Why You Need One. <credit: This section was copied from Made2Mentor> What is a Date (Calendar) Table? For the purposes of this article a Date Table is a dedicated table containing a single record for each day in a defined range. They include fields with descriptive attributes for each day such as…
-
“Big data” on AWS – Redshift
“Big data” is hot, hot, hot (Gartner hype cycle) and now supported by Amazon Web Services. Although pitched as “Big data” it will be very interesting to see the tools offering. I provide services to small to medium-sized enterprises and I am interested in how AWS can support the data warehousing requirements of these organisations.…
Dr James Bayley 