Blog Archives

Building slowly changing dimensions from salesforce.com 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 salesforce.com. The primary problem is that the case history is an audit trail for

Posted in Salesforce.com 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 Salesforce.com, Transformation Tagged with: , ,

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

Just a word of warning that Salesforce.com 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 Salesforce.com Tagged with: , , ,