ORA-01427: single row subquery return more than one row

Question

When I run the mapping in ODI it will getting the issue

And am add rownum=1   in join condition interface successful but data is not loaded in target table.

And scenario also executed but still getting same error in ODI

How to resolve the issue

Could you please help me anyone.

Thanks

Steve F-2 · Accepted Answer

Hi,

This community is for Oracle Business Intelligence (OBI), it is not for Oracle Data Integration (ODI)

Please search/check for other forums related to ODI.

This is probably the one you want to ask in:

https://community.oracle.com/customerconnect/discussions/tagged/225-oracle-data-integrator/p1