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!

Question on CDC

7688438Jun 15 2011

Hi Gurus,

We are trying to apply CDC on my sql database tables.We do have 5 tables in our source dB like customer,customer address,customer phones,customer email,customer preferences

customer is the parent and remaing 4 are childs

i have created 5 interfaces
1) customer
2)customer address(join between customer and custmer address and journalized data only option on customer address)
3) customer phones(join between customer and custmer address and journalized data only option on customer phones)
4)customer email(join between customer and custmer address and journalized data only option on customer email)
5) customer preferences(join between customer and custmer address and journalized data only option on customer preferences)

source database:my sql
target :oracle
CDC type:Simple
ODI:11G

Q1)what is the JKM can we use?

Q2) what are the LKM,IKM can we use?

Q3) is it correct to use simple CDC or....do we need to apply Consisitent?

Thanks in advance
Raj

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2011

Added on Jun 15 2011

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

0 comments

83 views