week5 课上笔记

1. window function

lead/lag

1. lead 1） wrong ex：

lag

cumulative sum

2. slowing changing dimensions

type 0
type 1-overwrite

type 2- add new row
type 3- add new atrribute

1. referential integrity