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!

union in ODI using KM

576435Jun 5 2007 — edited Jun 13 2007

Hi,

I am trying to do union between 2 tables in ODI. It worked the following ways :-

1) By writing two interfaces and writing package on it.
2) Writing view on the tables in the database & then using this as a source in the interface

But I could not get the third way i.e. using KM. How do i do union between tables using LKM? I tried modifying the LKM SQL to SQL, but that did not work..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2007

Added on Jun 5 2007

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

5 comments

977 views