DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Capturing a subset of the data contained in various decision support systems
|
|
|
Capturing all of the data contained in various decision support systems .
|
|
|
Capturing a subset of the data contained in various operational systems
|
|
|
Capturing all of the data contained in various operational systems
|
Detailed explanation-1: -The extract process is stated as capturing a subset of the data contained in various operational systems.
Detailed explanation-2: -The Extract Process creates an Extract File that contains the selected set of related rows from one or more tables and, if requested, the object definitions for those tables. The Extract File is used as input to the Move Insert, Load, Create, and Convert processes.
Detailed explanation-3: -ETL stands for Extract, Transform, Load and it is a process used in data warehousing to extract data from various sources, transform it into a format suitable for loading into a data warehouse, and then load it into the warehouse.
Detailed explanation-4: -Data extraction is the process of collecting or retrieving disparate types of data from a variety of sources, many of which may be poorly organized or completely unstructured.
Detailed explanation-5: -The process of extracting data includes locating and identifying the relevant data, then preparing to be transformed and loaded. Transformation is where data is sorted and organized. Cleansing-such as removing missing values-also happens during this step.