The problem with that is that there is no convenient way to roll up a higher level and calculate an aggregate of all ... Figure 8-17 shows a simplified Entity- Relationship diagram with an employee table with a recursive relationship along ... Kettle provides a Closure Generator step to populate these transitive closure tables.
|Title||:||Pentaho Kettle Solutions|
|Author||:||Matt Casters, Roland Bouman, Jos van Dongen|
|Publisher||:||John Wiley & Sons - 2010-09-02|