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.
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables
Take a look at this video about Talend Integration with Databricks