Table SOCIAL_INTERACTION_CHANNEL_USAGE_FACT

DescriptionA fact table that captures the social interations of the customer.

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
DescriptionChannel usage measure indicates the channel usage 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
DescriptionUnique identifier of the social channel.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_DIMENSION_ID
DescriptionIndicates the interaction date.
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