Today I was developing a transformation in Kettle & using "Database lookup" step in it. During development I realised that one more column need to be added into the lookup table and then I added that column in database using ALTER TABLE statement.
But in transformation, when I clicked on "Get Lookup Fields" button of "Database lookup" it was not showing the newly added column. I removed the "Database lookup" step from the transformation and then added it back (hoping that it will now show all the columns present in database) but still it was not showing the newly added column.
After googling, I found the following option to handle the above issue:
Go to the main menu action, select Tools -> Database -> Clear Cache
After clearing cache, the newly added column start appearing into the "Database lookup" step.
But in transformation, when I clicked on "Get Lookup Fields" button of "Database lookup" it was not showing the newly added column. I removed the "Database lookup" step from the transformation and then added it back (hoping that it will now show all the columns present in database) but still it was not showing the newly added column.
After googling, I found the following option to handle the above issue:
Go to the main menu action, select Tools -> Database -> Clear Cache
After clearing cache, the newly added column start appearing into the "Database lookup" step.
