Corey Webster, a Project X Ltd. consultant, just sent me an email with a neat idea. I have been writing in several of my blogs about how golf is a great analogy for life. One example is to play it as it lies which I interpret as taking life as it is handed to you.
In contrast to that Corey suggest that a great golf analogy for ETL is Lift, Clean, and Place. For you non-golfer, we use lift clean and place when the course condition are poor. We are sometimes allowed to lift the ball, clean it and place it down on the grass.
So with ETL, we lift the data from another spot, transform (clean) the data, place it in the data warehouse. It is really important that when we lift, clean and place in golf we do it according to the rules of golf. Similarly in ETL, we must conform to the business rules.
I have always thought if we look hard enough we can find a metaphor in golf for almost everything.
Thank you, Corey.