v_FACT_INTERACTIONATTRIBUTE
The interaction attribute fact table relates interactions to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INTERACTIONATTRIBUTEFACTID | bigint | BBDW.[FACT_INTERACTIONATTRIBUTE].[INTERACTIONATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTEDIMID] |
| INTERACTIONFACTID | int | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[INTERACTIONFACTID] |
| INTERACTIONSYSTEMID | nvarchar(255) | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[INTERACTIONSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_INTERACTIONATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_INTERACTIONATTRIBUTE] as
select
ia.[INTERACTIONATTRIBUTEFACTID],
ia.[ATTRIBUTEDIMID],
ia.[INTERACTIONFACTID],
ia.[INTERACTIONSYSTEMID],
ia.[ATTRIBUTESTARTDATEDIMID],
ia.[ATTRIBUTESTARTDATE],
ia.[ATTRIBUTEENDDATEDIMID],
ia.[ATTRIBUTEENDDATE],
ia.[ATTRIBUTEVALUE],
ia.[ATTRIBUTEISCURRENT],
ia.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_INTERACTIONATTRIBUTE] ia
left join BBDW.[DIM_ATTRIBUTE] a on ia.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);