- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.5K On-Premises Infrastructure
- 137.7K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Slowly Changing dimension - IKM Oracle....
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