v_DIM_CONSTITUENT
The constituent dimension is used as an intermediate dimension for use in many to many relationships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTDIMID | int | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDIMID] | |
| CONSTITUENTADDRESSDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDIMID] |
| CONSTITUENTADDRESSDETAILDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDETAILDIMID] |
| CONSTITUENTADDRESSFLAGDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSFLAGDIMID] |
| CONSTITUENTADDRESSTYPEDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSTYPEDIMID] |
| CONSTITUENTAGE | int | yes | BBDW.[DIM_CONSTITUENT].[AGE] |
| CONSTITUENTDEMOGRAPHICDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDEMOGRAPHICDIMID] |
| CONSTITUENTINFORMATIONDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTINFORMATIONDIMID] |
Definition
Copy
CREATE view [BBDW].[v_DIM_CONSTITUENT] as
select
[CONSTITUENTDIMID],
[CONSTITUENTADDRESSDIMID],
[CONSTITUENTADDRESSDETAILDIMID],
[CONSTITUENTADDRESSFLAGDIMID],
[CONSTITUENTADDRESSTYPEDIMID],
[AGE] [CONSTITUENTAGE],
[CONSTITUENTDEMOGRAPHICDIMID],
[CONSTITUENTINFORMATIONDIMID]
from BBDW.[DIM_CONSTITUENT]