DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data Cleansing
|
|
|
Business questions
|
|
|
Data Acquisition
|
|
|
Data Profiling
|
Detailed explanation-1: -Design methods In the bottom-up approach, data marts are first created to provide reporting and analytical capabilities for specific business processes. These data marts can then be integrated to create a comprehensive data warehouse.
Detailed explanation-2: -Step 1: Determine Business Objectives The company is in a phase of rapid growth and will need the proper mix of administrative, sales, production, and support personnel. Key decision-makers want to know whether increasing overhead staffing is returning value to the organization.
Detailed explanation-3: -In general, building any data warehouse consists of the following steps: Extracting the transactional data from the data sources into a staging area. Transforming the transactional data. Loading the transformed data into a dimensional database.