Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error in importing data from sql server data source in ODI

3476882Jun 4 2017 — edited Jun 5 2017

Hello,,

I'm facing a problem when I try to build a date dimension with hierarchy "SQL Server Data Source"..

in the begging when I try to Run the mapping.. the error was in merge statement which is missing semi colon (Integration mode was merge).

later I changed the knowledge module into incremental Update "which ran correctly on the year level" but when I added the month level and try to run the mapping

it gave me the following error:

ODI-1228: Task Insert flow into I$ table-IKM MSSQL Incremental Update- fails on the target connection HRMS.

Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]'FUNC_NVL' is not a recognized built-in function name.

can anyone help me to solve this issue?

thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2017

Added on Jun 4 2017

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

3 comments

323 views