Ask Your Question
0

How to achieve CDC using MySQL Binary Log and JDBC lookup when there are large number of tables?

asked 2018-09-25 07:20:38 -0500

Maithri gravatar image

I am trying to achieve CDC from multiple tables.My origin is MYSQL binarylog and used JDBC lookup Processer to perform my join query and used where table1.id=${record:value('/Data/id')} condition for mapping the changed data.This worked fine untill the number of tables where 2-3.Now as i have n number of tables to be included (say 7-8) how to map the changed data from mysql binarylog origin to the join query having such a big number of tables?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2019-06-20 04:13:49 -0500

Maithri gravatar image

Using seperate JDBC Lookups for all the driver tables solved the issue

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-25 07:20:38 -0500

Seen: 192 times

Last updated: Jun 20