Skip to Main Content

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!

Migrate data from Oracle to DB2

3756339Aug 6 2018 — edited Aug 7 2018

Hello,

In odi11 I was able to use Oracle -> DB2 without the usage of LKM.

In odi11 I would do it by specifying my own staging area.

When I try to do it in odi12 the AP node still stays and I can't remove it.

Is there a way to remove the AP node (LKM)?

Example picture of what I want in:

pastedImage_0.png

And my problem in ODI12:

pastedImage_1.png

miscellaneous:

I can't use LKM and I can't create a staging table on the db2 side.

I tried making the staging area the same as my source area.

I also can't make topologies fall in the same main topology.

If possible I would like for the solution to be the same as it was in odi11 (explicit set on staging area without the need to use the lkm)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2018
Added on Aug 6 2018
2 comments
155 views