Effective in version 10.0, Informatica dropped support for pushdown optimization to ODBC sources and targets that use a provider type of "Other." You must use a provider type that is database-specific.