I've change the contents of my dim table. So far so good, but when I use some existing tranformation to get me the ID from the table and a some extra field the data is not correct on the that field.

If I disable DIM lookup / Update step cache the the result seems to be ok, but i need the cache actvated otherwise I'll get some HY000 error from InfiniDB.

Can anyone explain me how the dim lookup update cache works and how can i clear it ?

Thanks in advance
Eduardo Barbosa