4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


Paul te Braak


Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals.  This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model.  He holds several qualifications including MCT, CA, MIT, MComm.

http://www.paultebraak.wordpress.com http://paultebraak.wordpress.com/feed/

Blog posts RSS

Biml XIII – Oledb Command Part II – Return Variables 18 Dec 2014
In our prior post, we looked at the Oledb Command, a data flow transform that fires a statement for each row in the pipelines dataset. That post, we used generic parameters that were defined in our query. For example our query was;   The transform allows us more flexibility and we will look at some ...

Biml XII – Oledb Command (Dataflow transformation) 17 Dec 2014
The data flows OLEDB Command executes an SQL statement for each row of the data flow. A good example of its use is the update of expired records end dates for type 2 changed dimensions. I’ve briefly discussed the logic for roll your own type 2 (changing) attributes here with the need to ...

Biml XI – Conditional Splits in Data Flows 17 Dec 2014
At first thought, I don’t see a huge need for conditional splits in SSIS, separating the stream (as it were) is something that I usually try and do at the source. That is, we should only bring in as much data as is required by the transform. However, in thinking about it, the transform is ...

Biml X – Derived Columns 10 Dec 2014
This post looks at the biml requirements and functionality of derived columns – how to apply logic to a column (replace a value) and add new columns. The scenario is pretty simple and builds on our other concepts of but now includes a little more ‘business logic’ (albeit simple) so we ...

Biml IX – The Lookup 07 Dec 2014
Our previous posts biml data flows have only included extractions and destinations. We have looked at moving data (the relation way) here and error configuration here. These posts have set the framework for discussing other dataflow transformations that are commonly used. Perhaps the most common of ...