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!

How to implement cdc when there are 2 source tbls to populate one trge tb

759013Feb 22 2011 — edited Mar 8 2011

I am new to ODI and trying to implement CDC. Using Oracle 10g as source and 11g as target. For one to one source and target all works fine. Problem arises then I try to use two tables as source joined by PK-FK and one TRGT table.
In the interface itself we can check Journalize data only for one table so the change in other tables can not be transfered to target Table. The option for the other table gets grayed out.

Following are the steps I am performing.
1. Set the Model to Simple journalizing and selecting JKM oracle simple
2. Adding both source tables to CDC by right clicking on source tables
3. Starting Journal by right clicking on source tables.

Creating an interface with both journalized tables as source and mapping them to target table. However we can only check JOURNALIZED DATA ONLY option for one table. Now if I go back and make changes to both than tables. One the source marked as JOURNALIZED DATA ONLY changes get posted.

How can we make changes made to table not marked as JOURNALIZED DATA ONLY be posted to target table.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2011

Added on Feb 22 2011

#business-intelligence-applications, #data-integrator, #interface, #odi, #oid, #oracle, #system-management-and-integration

8 comments

296 views