If there are no timestamp columns in the source how does the watermark works? Does it handle or need a watermark column?

You could use any other incremental column on which we can run SQL max or min functions as a watermark column for incremental ingestion. Providing a watermark column is a prerequisite for CDC ingestion.