When I do a lookup with a mysql 5 table I get the following error:
'Press OK to remove invalid keys'
There I press cancel because:
1. The DB Admin would kill me I I alter one of his tables
2: I normally have only read-access to the database
What causes this message and what can I do to avoid it?
So, you're in the tMap, just after drag&dropping a column from main input to lookup input. Don't take care of this warning, it just says that if you use only one column to join the 2 inputs, Talend Open Studio considers that there can be only one column in the key of the lookup input. Drag&drop another field from main input to lookup input and your second column in the key of the lookup input will come back.
Hey, it's magic :-)