Refresh : Data Refreshing is the process of propagating the updates from the source to the corresponding data on the data warehouse.It is performed on a regular known schedule ,so that the data warehouse is updated periodically.It depends on business needs and must be known by clients.
The two important issues with data refreshing are.
1.When to refresh and
2.How to refresh.
Usually,a refresh operation is performed daily or weekly .The refresh interval is defined by the warehouse administrator,depending on user needs. Refresh techniques may depend on characteristics and capabilities of the data base servers.The time interval which is set for data refreshing should be done carefully,because a very short interval will typically result in inefficient use of network bandwith and processor resources,On the other hand,a long interval may result in outdated data.Sometimes,the interval between refreshing is too small that it increases the load on servers.
Data refreshing is done in order to synchronize data at source and data warehouse.So that the final data is correct and consistent.
The two important issues with data refreshing are.
1.When to refresh and
2.How to refresh.
Usually,a refresh operation is performed daily or weekly .The refresh interval is defined by the warehouse administrator,depending on user needs. Refresh techniques may depend on characteristics and capabilities of the data base servers.The time interval which is set for data refreshing should be done carefully,because a very short interval will typically result in inefficient use of network bandwith and processor resources,On the other hand,a long interval may result in outdated data.Sometimes,the interval between refreshing is too small that it increases the load on servers.
Data refreshing is done in order to synchronize data at source and data warehouse.So that the final data is correct and consistent.
0 comments:
Post a Comment