Even when I don't have validation errors, it can be hard for me to know when my mapping is behaving as intended prior to committing to the full load.

Provide me with more tools to preview and validate with a subset of data that the full load will perform as expected.