Hi all,
I encounter the error message ODI-1228: Task Historize old rows-IKM Oracle Slowly Changing Dimension. Caused by: ORA-01427: single-row subquery returns more than one row.
It's similar to the cause in the posting SCD type 2 :Error at Historize old rows
The natural key is not unique in the source.
Sample Source (Text File)
| ID | Name | Service Plan | Last Access Date Time |
|---|
| 0001 | Joe | Plan A | 2020-01-01 01:00 |
| 0001 | Joe | Plan A | 2020-01-01 02:15 |
| 0002 | Tom | Plan C | 2020-01-01 01:15 |
Target Table
ID - Natural Key
Seq No - Surrogate Key
Name - Add row on change
Service Plan - Add row on change
Last Access Date Time- Overwrite on change
Starting Timestamp
Ending Timestamp
Current Flag
I would greatly appreciate if someone could provide a solution on how to resolve the error.