_Paul_te_Braak.png

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 V – Precedence Constraints 24 Nov 2014
In prior posts, precedence constraints have been managed through the package setting for ConstraintMode. This assumes either a parallel execution (ie ConstraintMode=“Parallel“) or sequential execution (ie ConstraintMode=“Linear“). The ConstraintMode is a mandatory property ...

BIML IV– Extracting All Tables to Raw Files 10 Nov 2014
Perhaps the first task of any (DW/ DM) project is to extract data – after all it’s the E in the ETL isn’t it? I know there’s a lot more that goes on here but it’s the most boring job I can think of doing and one which inevitably has to be done. In a […]

BIML III – Extracting Database Tables to Raw Files 09 Nov 2014
In a previous post, we looked at extracting a table to a flat file. Personally, I am not a huge fan of flat file output because you lose so much metadata when a table with all its data types are dumped into text. To preserve this information, I would much rather use a raw file […]

To Automate or Not? – The Pros and Cons of Data Warehouse Automation 28 Oct 2014
I have been thinking about data warehouse automation for at least 2 years now. That’s just a long enough time for me to see the pros and cons, examine the state of affairs, consider the consequences of both camps and lastly consider my reaction to those consequences. I’ve come to ...

BIML II – Extracting Database Tables to Text Files 27 Oct 2014
In this post we look at the Biml required to generate a SSIS package that copies data from a table to a flat file (that is, a text file output). It’s a pretty simple example but one that can build on our prior knowledge. We have already gone over the basics of Biml in our […]