Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have created a CDC tables while it's working fine when ever i used run button in talend.
Same jobs after scheduled these build jobs using task scheduler for every hour am getting ZERO records from these CDC tables.
source destination
mssql ----------------->HIVE
NOte: From client side the mssql database is dropping and recreating every night 10 pm.IS this cause any issue am getting zero records in hive by CDC tables.
Can anyone help me for this issue to resolve..
@saibabu ,what was the scheduled time? is it same time dropping and creating database ? if yes it could be problem.
Hi @saibabu ,
of course it could be a problem
Talend use trigger based CDC, so when you drop the database, it must drop triggers on tables