Download Aptitude Crack
img not found img not found

Data Warehousing

Q1: The generic two-level data warehouse architecture includes which of the following?

A At least one data mart

B Data that can extracted from numerous internal and external sources

C Near real-time updates

D All of the above.

ANS:B - Data that can extracted from numerous internal and external sources

In this Generic Two-Level Architecture we have 2 layers:

1. Bottom Tier

2. Top Tier

Bottom Tier:

In Bottom Tier data from different source systems are extracted and loaded to Staging area where all the data is cleaned and changed to standard or common format and transformations are applied to the data and is loaded into the data warehouse.

Top Tier:

It is nothing but the reporting layer, where business users execute their reporting query\'s and use the results in decision making.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.