Step 2: Synchronizing the staging database
Synchronizing the staging database is the second step in the data integration process. Synchronization can occur many times because data integration is an iterative process when models and dimensions are created or modified in 规划业务建模器. You can also script synchronization by using the 规划命令实用工具. For more information, see Scriptable data integration.
The synchronization operation overwrites the existing tables for those dimensions and models that you select.
To synchronize dimension and hierarchy data that has changed because of actions in 规划业务建模器, you can run a partial synchronization. For more information about the tools that you can use to run a partial synchronization, see Step 5: Loading data from staging to application database
The following are considerations and procedures for synchronizing dimensions, models, and associations.
- About synchronizing dimensions and models
Provides helpful information about synchronizing models, In addition, provides recommendations and best practices for synchronizing data.
- Synchronize dimensions
Describes the steps that you can follow to synchronize a specified dimension.
- Synchronize models
Describes the steps that you can follow to synchronize models, dimensions, hierarchies, and related annotations.
- About the structure of the staging database
Describes the general structure of the staging database after synchronization.