I have a requirement where in I need to run ETL job when a set of table gets updated in data base, in real-time mode. In those tables the rows can either be updated or inserted.
One approach is to run the ETL job at certain intervals. In each run, collect the rows updated, inserted from previous run.
Is there any other approach I can use to do this job.
thank you,
