Friday, October 28, 2011

Kettle cleaning the database cache

Sometimes when you're doing extreme bi (or bi on the fly, not in a production environment of course), but just for the sake of it , you realize that is necessary to make changes to your data warehouse schema. The issue when working with Kettle is that if you previously told the tool to fetch field data from a table, it won't update to the latest changes automatically, so you'll need to clean the database cache of the database you made the changes to in order to update  its meta-data.

http://atutility.com/content/pentaho-kettle-database-cache

http://ramathoughts.blogspot.com/2010/08/dealing-with-kettle-dbcache.html

No comments:

Post a Comment