|
|
|
|
|
|
Each tuple in the fact table represents a summary of the user clicks done during browser session.
Field Name |
Data Type |
Description/Example |
Date_Key |
Integer |
Date Key |
Session_Key |
Integer |
Foreign Key, references Session_Dimension table |
Customer_Key |
Integer |
Foreign Key, references Customer_Dimension Table |
ClientIP_Key |
Integer |
Client IP Address, Foreign Key, references IPAddress_Dimension Table |
ServerIP_Key |
Integer |
WebServer IP Address Foreign Key, references IPAddress_Dimension Table |
UserAgent_ID |
Integer |
Foreign Key, references UserAgent_Dimension table |
Page_Id |
Integer |
Foreign Key, references Page_Dimension table |
Referrer_Page_id |
Integer |
Referring Page id. |
CreditCard_ID |
Integer |
Foreign Key, references CreditCard_Dimension Table |
Num_Errors |
Integer |
Number of Errors encountered while browsing |
KBytes_Downloaded |
Integer |
Amount of Data downloaded at client machine |
Browsing_Time_Per_Page |
Integer |
browsing time in minutes |