[Feature] 多sink模式下（非single-sink）未来会支持新增表等DML操作的同步吗

### Search before asking

- [x] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.

### Description

目前使用cdctools发现sink端是没有处理新增表等DML操作的，社区有这块规划吗

### Use case

_No response_

### Related issues

_No response_

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Review the multi-sink CDC sink path and compare it with the existing single-sink behavior described in the issue; no file or test is named, so first locate those entry points in the repository. Done should be a maintainer-confirmed scope and an agreed behavior for synchronizing new-table and other DML events in non-single-sink mode.

Written by the indexing model from the issue text.