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!

Load data from one table to another table of 2 different schemas

2942624Dec 28 2015 — edited Dec 29 2015

Hi,

We have a requirement to insert data to a table in one schema from a table which is in other schema in ODI.

We are able to do this by creating interfaces and mappings. But, we are now looking to do it using SQL instead of ODI interfaces.

Is it possible to achieve this using SQL statements as we have source and target data sources defined in ODI.

should be like 'Insert into src.table select * from tar.table'

Thanks..

This post has been answered by ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTD on Dec 29 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 26 2016

Added on Dec 28 2015

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

8 comments

1,883 views