I am using a SQL Server Change Tracking origin in the pipeline. There are many tables in the SQL source.
If I don’t turn on the “Product Events” option, the pipeline can process data from all tables, as expected. However, because there is no event, the pipeline must run continuously, which I would like to avoid.
If I turn on the “Produce Events” option, the pipeline would stop after processing data from only 1 table. This is a problem because I need to process data from all tables.
What can I do to make it process all tables before producing the event?
Thanks a lot for your attention! I hope to hear from you soon!