[PDI-9815] 'Dimension lookup/update' step causes error: "Unable to retrieve data type of return fields because of an unexpected error" with Vertica

The fix + unit test