What is the purpose of the fact table and dimension tables shown in the property sales DM?
What will be an ideal response?
The most useful fact tables contain one or more numerical measures, or “facts,” that occur for
each record. In Figure 32.2, the facts are offerPrice, sellingPrice, saleCommission, and
saleRevenue. The most useful facts in a fact table are numeric and additive, because data
warehouse applications almost never access a single record; rather, they access hundreds,
thousands, or even millions of records at a time and the most useful thing to do with so many
records is to aggregate them.
Dimension tables, by contrast, generally contain descriptive textual information. Dimension
attributes are used as the constraints in data warehouse queries. For example, the star schema
shown in Figure 32.2 can support queries that require access to sales of properties in Glasgow
using the city attribute of the PropertyForSale table, and on sales of properties that are flats
using the type attribute in the PropertyForSale table.
You might also like to view...
Kernel-level threads are often described as ________ thread mappings.
a) one-to-one b) one-to-many c) many-to-one d) many-to-many
A timestamp can prove that your database has or has not been modified since you applied your signature
Indicate whether the statement is true or false
You must use Scenario Manager to create a scenario
Indicate whether the statement is true or false
E:\Regions[Duluth.xlsx]1stQTR'!A1 is a reference link to a source file in different directory than the destination file.
Answer the following statement true (T) or false (F)