Cascading Configuration Real-World Use Cases
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.
Description of the illustration cascading_data_mart.png
The following image shows central databases that are replicating changes from the Headquarter to the State to the County level in a hierarchical manner.
