A Mediator deals with data differences, like a real-world broker of foreign currencies. A Mediator either directly changes the data or is aware of the changes previously made. Like a Broker, its goal is to get the data from one location to another, taking into account how the locations differ. ETL tools are Mediators.
- Changes or manages changes between the source and destination data.
- High-risk tools because of changing data.