Which of the statement hold true about refreshing a data warehouse?

Options
- It is a process of managing timing differences between the updating of data sources and the related data warehouse objects
- Updates to dimension tables may occur at different times than the fact table
- The data warehouse administrator has more control over the load time lag than the valid time lag.
- None of the above

CORRECT ANSWER : None of the above

Discussion Board
Refreshing a data warehouse

You must update your data warehouse on a regular basis to ensure that the information derived from it is current. This process of updating the data is called the refresh process. Extraction, transformation and loading (ETL) is done on a scheduled basis to reflect changes made to the original source system.

Prajakta Pandit 03-16-2017 06:42 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲