Exam 9: Data Warehousing

Factless fact tables may apply when:

________ data refers to the before and after image of a transaction.

A dependent data mart is filled from the enterprise data warehouse and its reconciled data.

Scalable technology is critical to a data mart.

A(n)________ is an integrated,subject-oriented,updateable,current-valued,detailed database designed to serve operational users as they do their decision support processing.

An operational data store (ODS)is a(n):

Reconciled data are data that have been selected,formatted,and aggregated for end-user decision support applications.

________ technologies are allowing more opportunities for real-time data warehouses.

What is OLAP and what types of OLAP tools are available?

Data in which changes to existing records are written over previous records,thus destroying the previous data contents are called ________ data.

The representation of data in a graphical format is called data mining.

The level of detail in a fact table determined by the intersection of all the components of the primary key,including all foreign keys and any other primary key elements,is called the:

There are applications for fact tables without any nonkey data,only the foreign keys for the associated dimensions.

The real-time data warehouse is characterized by which of the following?

A database action that results from a transaction is called a(n):

________ metadata describe the data in the various operational systems that feed the enterprise data warehouse.

The grain of a data warehouse indicates the size and depth of the records.