FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The time horizon in Data warehouse is usually ____
A
1-2 years.
B
3-4years.
C
5-6 years.
D
5-10 years.
Explanation: 

Detailed explanation-1: -12. What is the time horizon in the data warehouse? Answer-C) The time horizon in the data warehouse is 5-10 years.

Detailed explanation-2: -Horizon allows large sets of data to be joined together to provide a 360-degree view of an individual customer. It provides powerful data visualization, while at the same time allowing users to pull out smaller data samples for specific trend analysis.

Detailed explanation-3: -Real-time data warehousing involves the continuous process of loading data into a warehouse and making it instantly available to the different business functions that require it. This is unlike the traditional data warehousing approach, where data is loaded in batches overnight or hourly schedules from source systems.

Detailed explanation-4: -State whether True or False: Data warehouse is generally updated in real-time. Answer-B) False. The Data warehouse is not generally updated in real-time.

There is 1 question to complete.