A data movement model (DMM)
provides a global view of the movement of information in your organization.
You can analyze and document where your data originates, where it moves to,
and how it is transformed on the way, including replications and ETL.
Creating a Data Movement Model
- To create a new, empty DMM - Select , and choose Data Movement Model.
- To reverse engineer replication processes into a DMM from a consolidated database connection - Select .
The following types of diagrams are available:
-
A
data movement diagram provides a high-level
graphical view of the movement of your information, including data
sources, replications, and ETL operations.
-
A data
transformation diagram provides a graphical view of the
inputs, outputs, and steps involved in a data transformation
task.
-
A
transformation control flow diagram provides a
graphical view of the order in which a series of data transformation
tasks is linked together in a control flow.
Creating Replication and Transformation Environments
- To create a replication environment, select .
- To create a transformation process to transform data from a PDM, select .
- To create a transformation process from existing PDM-to-PDM mappings, select .
Documentation
For detailed documentation, see Data Movement Modeling.