Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Create Table index and Constraints

cdcrAug 14 2018 — edited Aug 16 2018

Hello,

I am using ODI 12c to map from SQL source tables to Oracle 12c target tables. There are existing indexex/constraints on SQL source tables but those indexes/constraints are not transfered to Oracle target tables.

In TOAD, I see data is loaded correctly. However, I do not see any indexes and constraints are transfered over to Oracle target tables.

I can not find anywhere in the ODI studio that mentions about indexes or constraints. Do I need to create those indexes or constraints manually in the Oracle database or ODI studio does it for me automatically during mapping?

Thank you in advance.

This post has been answered by cdcr on Aug 16 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2018

Added on Aug 14 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

5 comments

1,859 views