Blog Archives

Building slowly changing dimensions from data

An interesting problem arose recently. A colleague was trying to build a type 2 slowly changing dimension (SCD 2) using data from the case history object in The primary problem is that the case history is an audit trail for

Posted in Tagged with: , , ,

Extract, Load and Transform with Salesforce

Recently I had an interesting situation where I needed to load an account hierarchy daily¬†from a single file. The tricky bit about this was that I couldn’t make any changes to the input source file as it came from a

Posted in, Transformation Tagged with: , ,

Salesforce have moved their documentation and Google hasn’t caught up yet.

Just a word of warning that have moved all their documentation into a different location and format and Google’s indexes haven’t caught up yet. So if you do a search for something like ‘salesforce sObject methods’ pretty much all

Posted in Tagged with: , , ,