![]() These variations with a transactions system, where often only the most current file is kept. For example, one can retrieve files from 3 months, 6 months, 12 months, or even previous data from a data warehouse. ![]() Historical information is kept in a data warehouse. It requires performing data cleaning and integration during data warehousing to ensure consistency in naming conventions, attribute types, etc., among different data sources. Therefore, data warehouses typically provide a concise and straightforward view around a particular subject, such as customer, product, or sales, instead of the global organization's ongoing operations.Ī data warehouse integrates various heterogeneous data sources like RDBMS, flat files, and online transaction records. Important Points Characteristics of Data Warehousing:Ī data warehouse target on the modeling and analysis of data for decision-makers. ![]() Example: ad-hoc query, multi-table joins, aggregates. This is based on RDBMS technology, though the fact that this is better optimized for transactional systems can prove to be a challenge. The correct answer is (B), (D), (E) only.ĭata warehouse database is the central database and core component that forms the base for a data warehousing environment. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |