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