Debugging ETL SQL scripts can be frustrating because of the syntax used to create database objects. In this post I share some tips to write syntactically and functionally better SQL scripts that are particularly useful when using SQL for ETL. All syntax written for Sybase IQ 15.4. Historically to avoid object already exists type errors…Continue readingSyntactically better SQL CREATE statements
UPDATE-6 July 2020: I have updated this post to be the landing page for all my posts on Open Source SQL Editors. There are many aspects of SQL editors that I will post in separate and probably smaller posts. Introduction Working in Business Intelligence (BI), I write and execute SQL statements every day. Actually it…Continue readingOpen Source SQL Editors
Nothing irritates me more than redoing BI reports because of an unclear specification. This is a total waste of time that I try avoid at all costs. Decision tables are a simple tool to facilitate effective communication of report logic between business users and BI developers. How many times have you sat through a meeting…Continue readingVisualising Client Reporting Specifications
Performance tuning SELECT statements can be a time consuming task which in my opinion follows Pareto principle’s. 20% effort is likely give you an 80% performance improvement. To get another 20% performance improvement you probably need to spend 80% of the time. Unless you work on the planet Venus where each day on Venus is…Continue reading6 Simple SQL SELECT statement performance tips
The first step when designing a fact table using Ralph Kimball’s dimensional modelling method is to decide on the grain of the table. Another way of describing the grain is the level of detail to store in your fact table. The accepted rule is that you should always store the data at the most detailed…Continue readingETL: Classify do not Filter out data
