PDI: Clone your data in Kettle! (Video Tutorial)In this tutorial we look at the cloning feature of Pentaho Data Integration/Kettle and use the power of the JavaScript step. Please watch the video here:Part 1:Part 2:Part 3:The files for this tutorial: Download the budget data here and the PDI/Kettle file here. You can find the video's also on YouTube:Video Part 1: click hereVideo Part 2: click hereVideo Part 3: click herePlease find below some more information:Code for 1st JavaScript step:function daysInMonth(iMonth, iYear){iMonth=iMonth-1;return...
Friday, 4 June 2010
Pentaho Data Integration: Full Outer JoinsCreating full outer joins in Pentaho Data Integartion (PDI aka Kettle) is a fairly straight forward approach ... let’s have a look at it:In this example we will be looking at data of an online acquisition process. We are facing the problem that the tracking hasn’t been implemented correctly, hence it can happen, that in a few cases we have pin insertions but no page impressions.This is a good example to use...
Subscribe to:
Posts (Atom)
