How to fix [Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

[Informatica][ODBC Oracle Wire Protocol Driver] Optional feature not implemented

You may get this error while trying to Preview data on Target in a Mapping Designer. I have also seen the same error from Source Qualifier Transformation while applying SQ properties. Let’s see how to fix this error.¬†This is a part of ODBC Data Source configuration, just follow the steps to fix the Issue.¬†

Optional feature not implemented.

Optional feature not implemented.
Error while trying to Preview data on Target
Optional feature not implemented.
Go to Source Analyzer, Menu Sources >> ‘Import From Database’
Optional feature not implemented.
Go to ODBC Data Source Administrator
Optional feature not implemented.
Select Oracle Data Source and ‘Configure’ it.
Optional feature not implemented.
‘Enable N-CHAR Support’ option might be disabled here, Just enable this feature and try again.
Optional feature not implemented.
Go to Target and preview the data Again, Issue is fixed now, You can view the result from Mapping itself instead of going to Database and query the table.

 

 

You May Also Like

About the Author: kvt

3 Comments

  1. Hi,I referred to your site and I tried Sorter transformation.But i get the following error while running the session:
    WRT_8229 Database errors occured
    ORA-00942:table or view does not exist
    Database Driver error…
    Function Name:Execute
    SQL Stmt:INSERT INTO Sales1(JOB_ID,TITLE,MIN_SAL,MAX_SAL) VALUES(?,?,?,?)
    Oracle Fatal Error
    Database Driver error…
    Function Name:Execute Multiple
    SQL Stmt:INSERT INTO Sales1(JOB_ID,TITLE,MIN_SAL,MAX_SAL) VALUES(?,?,?,?)
    Oracle Fatal Error

    Kindly help…

Leave a Reply to informatica developer Cancel reply

Your email address will not be published. Required fields are marked *