Day 4

Card Set Information

Author:
mcharliem
ID:
29701
Filename:
Day 4
Updated:
2010-08-12 16:56:50
Tags:
Day
Folders:

Description:
Day 4
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user mcharliem on FreezingBlue Flashcards. What would you like to do?


  1. What are the 3 benefits to having Facts?
    • - Report Developers don't need to worry about the Warehouse structure
    • - The Data Warehouse can contain fact columns with multiple names
    • - You don't have to resolve descrepencies in the Data Warehouse
  2. What types of Facts can be created with the Fact Wizard? And the Attribute Wizard?
    • Only Basic (Simple, Homogeneous) Facts can be created.
    • Both Compound and Basic Attributes can be created with the Attribute Wizard.
  3. What is a Fact Column Alias?
    It is the name and type of how the Fact will be stored in SQL Temp tables. Sometimes if there are multiple types or calculations, the alias will need to be adjusted to avoid an error.
  4. What are the 3 Types of Attributes to create?
    • Compound (primary key of multiple columns)
    • Homogeneous (same column names throughout)
    • Heterogeneous (different column names)
  5. What are the 7 components of the Architect Graphical Interface?
    • Warehouse Tables Pane
    • Project Tables View Tab
    • Hierarchy View Tab
    • Properties Pane
    • Project Objects Pane
    • Menu Bar
    • Toolbar

What would you like to do?

Home > Flashcards > Print Preview