Before you start to develop any data transformation you should explore your data (make data profiling). There are a lot of tools on the market that can help you with data profiling. But why to install and learn another software when you can use the tool you are familiar with? CloverETL is mainly data transformation tool but it can be easily used for data profiling as well (as I will show you in this blog post).
March 31, 2010