Hi,

I am using kettle to load data in MySQL database. The transformation has series of combination lookup/update, insert statements.

There is a database lookup step in the transformation which fails to lookup a value in one of the tables and generates error. The value is inserted in the table (the one which is looked into) by one of the previous steps in the transformation. When I query the database the after the transformation terminates, the value is actually present in the database. I am not getting why the lookup should fail.

Any help?

Thanks.