In a transitional database, additional filtering and transformation occurs before changes are replicated to the final dataset. This allows you to replicate changes from a source database to an transitional database, which in turn, is a source database to another end-target database.

You can set up even more complex replication topologies, as shown in the following examples.

The following image shows a DataMart configuration where the Data Warehouse is fed by multiple different sources and the data warehouse itself replicates data to different data marts.

The following image shows central databases that are replicating changes from the Headquarter to the State to the County level in a hierarchical manner.