Table CHANNEL_USAGE_FACT

DescriptionThis fact table identifies the channel usage across all customers.

Columns
CHANNEL_USAGECHANNEL_USAGE
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID

Column Details

 CHANNEL_USAGE
DescriptionThis measure identifies the number of times the channel is used by the customer.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHANNEL_DIMENSION_ID
DescriptionThe unique identifier of the channel dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_DIMENSION_ID
DescriptionThe unique identifier of the calendar date dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the individual customer dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse