I have been getting this error while I was trying to load data into SAP HANA table from Oracle Exadata as a source. I tried all options in DS job but still I have been getting this error. There are no transformations and it's straight pull. I was reading somewhere that I need to disable the primary keys in HANA tables and that will load the data successfully. Any ideas here on how to resolve this issue?
Job <JB_XXXX> is terminated due to error <70404>
DBS-070404 SQL submitted to ODBC data source <HANA_CONN> resulted in error Integrity constraint violation