In the transformation stage of a traditional extract-transform-load (ETL) pipeline for a data warehouse, data scrubbing is:
A process to upgrade the quality of data before it is moved into a data warehouse
During the transformation stage of a traditional extract-transform-load pipeline, data scrubbing detects and corrects errors, duplicates and inconsistent formats before the data is loaded into the warehouse. Its purpose is to improve data quality.
Important Questions from Data Warehousing and Data Mining
Identify the correct statement(s) about Data Warehousing (DW):
A. DW system must be acceptable to regulators and business community.
B. DW system must not be based on open source platforms
C. DW system must present information attractive to users.
D. DW system must be secure bastion that protects the information.
E. DW system must be adaptive to change.
Choose the correct answer from the options given below:
What does the following statement represent in data migration?
"Locate the useful information required to populate the customer relationship management and identify who maintains it, what it contains and how accurate it is."
Match List - I with List - II.
List - I
Data Warehouse Types Concept
List - II
Functions Meaning of Data Ware Houses
(A)
Data Marts
I)
Provides a fairly recent form of customer information file and is used as interim staging area.
(B)
Operational Data Store
(II)
Provides integration of data from many sources into a standard format.
(C)
Enterprise Data Warehouse
(III)
Describe the structure and some meaning about data
(D)
Metadata
(IV)
Subset of a data warehouse, typically consisting of a single subject area
Choose the correct answer from the options given below:
- Considering the following statements:
A. Data transformation is involved in Datamining process.
B. Online database is used in Data warehouse.
C. Classification is a measure of accuracy.
D. K-means clustering algorithm is based on the concept of minimizing the within-cluster variance.
E. Pattern evaluation is a process to identify knowledge based on interestingness measure.
Choose the correct answer from the options given below: An enormous collection of data on various topics from a variety of internal and external sources, compiled by a firm for its own use or for use by its clients, is called :
