Testing data transformations is generally not an easy task. When creating and testing a transformation you might want to get a data sample to check if your transformation works properly. In this point a question arises: How to create a representative data probe on the full data set? Obviously, the easiest way is to read just part of data from the beginning. But such data sample can be very unreliable. I've prepared a few simple graphs that create a data probe which can be regarded as representative for the full data set.[Continue reading]
Archives for January 2011
Transformations on CloverETL Server can be run by users in a very simple way by using just a web browser and a correct link. When a user click on the link, a transformation is triggered on the Server and requested data are generated. These data can be in several different formats as Excel spreadsheet, CSV file, XML, or HTML. One can even place a form on the web page that serves as a source for parameters for the transformation.[Continue reading]
Attractions in 2010
These are the posts and pages that got the most views in 2010.
Building DWH with CloverETL: Slowly Changing Dimension Type 2 May 2010[Continue reading]