ETL into a Market Basket Datamart - Data Warehouse Designs - page 121

tABle 7.6
Hierarchy Dimension
Object_key

Hierarchy_key

78 1124

98 1124

16 6543

43 6543

64 6543

15 9792

57 9792

87 9792

0 0

'(/(7()5200$5.(7B%$6.(7B%,B7$%/(B&255B+,(5$5&+<
,16(57,1720$5.(7B%$6.(7B%,B7$%/(B&255B+,(5$5&+<
,7(06(7B.(<
'5,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
+,(5$5&+<B.(<
&255B48$17,7<
&255B'2//$56
&255B&2817
6(/(&7
,7(06(7B.(<
'5,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
&+,(5$5&+<B.(<
680&255B48$17,7<$6&255B48$17,7<B680
680&255B'2//$56$6&255B'2//$56B680
$6&255B&2817
)520
0$5.(7B%$6.(7B%,B7$%/($
,11(5-2,10$5.(7B%$6.(7B+,(5$5&+<B',0(16,21%
21$'5,9(5B2%-(&7B.(< %2%-(&7B.(<
,11(5-2,10$5.(7B%$6.(7B+,(5$5&+<B',0(16,21&
21$&255B2%-(&7B.(< &2%-(&7B.(<
:+(5(
%+,(5$5&+<B.(<!&+,(5$5&+<B.(<
*5283%<
,7(06(7B.(<
'5,9(5B2%-(&7B.(<
'5,9(5B48$17,7<
'5,9(5B'2//$56
'5,9(5B&2817
&+,(5$5&+<B.(<
25'(5%<
'5,9(5B2%-(&7B.(<
&+,(5$5&+<B.(<

fIGure 7.4
Load Market Basket BI Table with correlation hierarchy.