The Kimball Group Reader

Index

1. 2NF (second normal form), c05¶0335–c05¶0339
2. 3NF (third normal form), c05¶0001
   1. business rules, c05¶0055
   2. Chris Date criticisms, c05¶0089
   3. complex schemas, c05¶0062
   4. versus dimensional modeling, c05¶0034
   5. dimensional presentation areas and, c05¶0339–c05¶0342
   6. incompleteness, c05¶0062
   7. primary criticism, c05¶0022–c05¶0030
   8. query complexity, c05¶0022
      1. performance for BI queries, c05¶0022
   9. real data, c05¶0062
   10. redundancy, c05¶0022
   11. uniqueness, c04¶0166
   12. usability, c05¶0022
       1. CIF use of 3NF, c05¶0308–c05¶0312
3. 34 subsystems of ETL, c11¶0036–c11¶0082
4. 64-bit architectures for data warehouse, c12¶0484, c12¶0783–c12¶0789

A

1. abstract dimensions, reasons to avoid, c09¶0223
2. abused users, c04¶0081
3. accumulating snapshot fact table, c06¶0096. See also grain (fact tables)
   1. combining with periodic and transaction grains, c08¶0133–c08¶0147
   2. comparison to other grains, c08¶0093–c08¶0099
   3. complex workflows and, c08¶0499–c08¶0527
   4. date dimension roles, c09¶0146
   5. fact table loader, ETL subsystem #13, c11¶0055
   6. nulls to be expected, c08¶0444
   7. pipelines and short processes, c08¶0103
   8. procurement example, c08¶0077–c08¶0086
   9. real time partition, c11¶0884–c11¶0890
   10. university and admissions example, c08¶0133
4. accurate counting, combining CASE and SUM, c09¶0237
5. actions, tracking, c13¶0005, c13¶0031
6. active archiving, c12¶0361–c12¶0378
7. activity based costing
   1. difficult environments for, c08¶0341
   2. modeling income statements, c10¶0624–c10¶0640
8. ad hoc attack, c02¶0169
9. additive facts, c01¶0089, c05¶0032–c05¶0040