1. window function
lead/lag
- lead 1) wrong ex:
cumulative sum
2. slowing changing dimensions
type 0
type 1-overwrite
type 2- add new row
type 3- add new atrribute
- referential integrity
下一篇:如何构建Star schema
type 0
type 1-overwrite
type 2- add new row
type 3- add new atrribute
让时间为你证明