Forum Stats

  • 3,770,702 Users
  • 2,253,155 Discussions


Slowly Changing dimension - IKM Oracle....

edited Apr 21, 2020 5:26AM in Data Integrator


Can I generate new assignments after initial load in a slow-change dimension in Oracle ODI?

I assigned some new fields and doing so generates this error ...

ODI-1228: Update Existing Rows Task -IKM Oracle Slow Change Dimension- Fails on destination connection TGT_GARDOP. Caused by: java.sql.SQLException: ORA-01427: single row subquery returns more than one row

I deallocate them and it works properly.

What do I need to configure so that the IKM takes me to add a new field to the source table?

What am I doing wrong?

Thank you. Mariano



  • SH_INT
    SH_INT Member Posts: 3,188 Bronze Crown
    edited Apr 21, 2020 5:26AM

    I would guess that the new fields you are adding to the source table means that the recordset you are bringing in now returns multiple records for the update key you have specified. Either you need to change the update key to ensure that it only identifies unique records in from the source or remove the field that is breaking the unique constraints.