@JothyGanesan , it should not have an impact. Delta supports concurrent operation. And since you will be deleting old rows there is low risk that you hit some error due to concurrency, because probably you won't need to modify the row you're going to delete at the same time. You can read about isolation level here:

Isolation levels and write conflicts on Databricks | Databricks Documentation