Book Contents

Book Index

Next Topic

Home

Customer_Dimension

This table describes the user demographic information. Data in this table is populated from parsing strings from web logs of server.

Field Name

Data Type

Description/Example

Customer_Key

Integer

Primary key

Name

Varchar

Name of customer

Email_ID

Varchar

Unique Mail id of customer

Sex

Char

Sex of the customer

Age

Integer

Age of customer

Annual_income

Integer

Annual income of the customer e.g. 50000 ($50000)

City

Varchar

Home city of customer

State

Varchar

Home state of customer

Country

Varchar

Home country of customer