Inital load of nonABAP table without primary key failed using SLT

[daniel_park]

Hi experts,

I am looking for ideas for replicating tables (Oracle) which have no primary key by SLT.

Many tables in customer landscape have no primary keys.
My customer doesn't have plan for fix their tables and moreover I have to replicate them to HANA DB.

I realized these key feilds are very important for SLT processing (especially in calculation step).

Is it possible to replicate oracle table without key fields?
If it is possible, could you let me know your idea?

Any idea will be welcomed.

Thank you.

Regards,

Jongwoo

[raulruiz · Accepted solution]

Hi

I am not sure if I get the full picture, but just in case: I understand source tables have no keys defined explicitly , but you know which fields are the actual key, right? (e.g. if we are talking about order items, you know that document number and item would be the unique-keys, while the remaining fields would be attributes). If you know these keys, you can define them on IUUC_DB_TAB_KEYS so that the auxiliary tables used behind the scenes consider those keys (but you need to be sure that they are unique to avoid duplicate key errors).

[daniel_park · Accepted solution]

Thank you Raul.

Let me try your idea and I will post the result.

I took vacation last week and I am sorry for my late reply. 🙂

Thank you again for your answer.

[daniel_park · Accepted solution]

It works!! Thanks a lot!! 🙂

[EasonLing]

2319897 - SLT – Replicating data from tables without primary key on DB level using a secondary DB connection to the target system