SLT from non-SAP (Oracle) - DEFERRABLE INITIALLY DEFERRED

Hi,

I'm trying to extract data from Oracle and load it into HANA via SLT. This works fine for some tables, but for others that do not have a primary key - not so much.

The issue is that the tables does not have a primary key, but only a unique index, but the unique index is defined as DEFERRABLE INITIALLY DEFERRED - as a result SLT will not read the table. We are looking into making the unique indexes non-deferrable, but would like to avoid changing the database.

Has anyone experiece a similar issue and found a workaround?

Thanks in advance,
Jacob