Business Intelligence And Data Warehousing Software Directory

Practical Example of Data Transformation Using Kettle

Details: A great Pentaho Data Integration (Kettle) tutorial which shows a real life example of ETL process for an entertainment vendor. It illustrates how to deal with a set of flat, tab delimited files, in a not user-friendly format and load them into a data warehouse. The ETL process includes interaction with text files, denormalization (row and field flattening), sorting, merges and joins. The tutorial helps understand how to use the Text file input and output, Sort Rows, Flattener, Merge Join and Java Script component in Kettle.