Kettle History Join plugin PDF Print E-mail
Written by Administrator   
Wednesday, 01 September 2010 08:15

Kettle History Join plugin

This plugin supply a method to join two different storicizable tables with date from/to pair. It builds the story of the entity in input with all states in the story.

For example:

the entity emplyee with datas:

ID,Name, Surname, date_from, date_to

1,Claudio, D'Angelo,2001-01-01,20010-01-01

and the deparment_assign entity with datas:

employee_id, dep_id, date_from, date_to

1, 999, 2001-01-01,2005-01-01

1,998,2006-01-01,2009-01-01

Will generate records like:

ID,Name,Surname, date_from, date_to, dep_id

1,Claudio,D'Angelo,2001-01-01,2005-01-01,9999

1,Claudio,D'Angelo,2005-01-02,2005-12-31,null

1,Claudio,D'Angelo,2006-01-01,2009-01-01,998

1,Claudio,D'Angelo,2009-01-02,2010-01-01,null

 

Last Updated on Tuesday, 01 February 2011 14:07