on 09-21-2018 6:38 AM
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
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.