SCD Types Flashcards
1
Q
Type 0
A
BookDim - originalPrice
2
Q
Type 1
A
BookDim - currentPrice
3
Q
Type 2
A
BookDim - price, startDate, endDate, remarks, currentFlag
4
Q
Type 3
A
BookDim - currentPrice, previousPrice
5
Q
Type 4
A
BookDim AND BookPriceDim - ID, startDate, endDate, Price, Remarks
6
Q
Type 6
A
BookDim - currentPrice, previousPrice, startDate, endDate, remarks, currentFlag
7
Q
For SCD 2, 3 and 6 what additional condition do we need when querying using price
A
where f.date >= p. start_date and f. date<= p. start_date
