Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
|
What are special dimensions?
|
indicators and flags left in the source data
|
|
|
What is solution 1 for special dimensions and the impact of this solution?
|
leave them unchanged in the fact table, but this will increase the size of the fact table dramatically
|
|
|
What is solution 2 for special dimensions and the impact of the solution?
|
create a separate dimension table for each one, but this would cause too many dimensions and slow the performance of the DW
|
|
|
What is solution 3 for special dimensions and the impact of the solution?
|
strip them out of the design,but then information will be lost
|
|
|
What is solution 4 for special dimensions and the impact of the solution?
|
create a single dimension table for all of the related indicators which will be a good design
|
|
|
What is the name of a single dimension table containing all the special dimensions?
|
junk dimension
|
|
|
What is a mini dimension?
|
serves the needs of relatively frequently changed or queried attributes in a monster dimension table
|
|
|
What is the rule of thumb for the number of dimension tables?
|
between 5 and 15
|
|
|
Name types of dimensions
|
analysis dimensions, role-playing dimensions, junk dimensions, mini dimensions
|
|
|
What causes too few dimensions?
|
when needed dimensions are left out
|
|
|
What causes too many dimensions?
|
several dimensions may not be independent and should be combined into a single dimension
|
