Hello everyone,
I'm working on File to Database solution, But i have face problem.
I'm using SCD (Slowly Changing Dimension) Type 1 Mapping, but when my file included more than 1 id value records, my mapping can't work.
More Detailed Error:
ODI-1217: Session INSERT_AND_UPDATE_ADDRESSES_Physical_SESS (849) fails with return code ODI-1298.
ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1240: Flow Physical_STEP fails while performing a Update existing rows-IKM Oracle Incremental Update- operation. This flow loads target table ALMS_ADDRESSES.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (50)" failed because child task "SERIAL-EU-DW_ADMIN_UNIT (80)" is in error.
ODI-1298: Serial task "SERIAL-EU-DW_ADMIN_UNIT (80)" failed because child task "Update existing rows-IKM Oracle Incremental Update- (180)" is in error.
ODI-1228: Task Update existing rows-IKM Oracle Incremental Update- fails on the target connection DW_ADMIN.
Caused By: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
I tried to eliminate same value records using "Subquery Filter" but nothing succeed.
Here's my mapping
Here's my filter condition:
and i execute my mapping, this error shown as down below:
My question:
How to perform incremental update when my source file include more than 1 key rows.
Here's my source file
as you can see 3000016832 value appeared more than 1, that's why causing error.
