Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
Data Warehousing
A multifield transformation does which of the following?
Converts data from one field into multiple fields
Converts data from multiple fields into one field
Converts data from multiple fields into multiple fields
All of the above
Correct Answer:
All of the above
← Previous Question
Next Question→
More Questions from
Data Warehousing
The role of the ETL process is to identify erroneous data and to fix them.
A data mart is designed to optimize the performance for well-defined and predicable uses.
Data in operational systems are typically fragmented and inconsistent.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Data in the data warehouse are loaded and refreshed from operational systems.
Every key used to join the fact table with a dimensional table should be a surrogate key.
Both status data and event data can be stored in a database.
Joining is the process of partitioning data according to predefined criteria.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments