Forum Stats

  • 3,770,702 Users
  • 2,253,155 Discussions
  • 7,875,552 Comments

Discussions

Slowly Changing dimension - IKM Oracle....

98f55c7f-71fb-4272-bca9-c8277ef74546
edited Apr 21, 2020 5:26AM in Data Integrator

Hi!

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

Tagged:
XavierGrosfils

Answers

  • 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.

    XavierGrosfils