Table FA_DIMENSION

DescriptionFinancial Advisor dimension. It defines all the financial advisor in the organization.

Columns
FA_DIMENSION_IDFA_DIMENSION_ID
NAMENAME

Primary Key
FA_DIMENSION_PKFA_DIMENSION_PK

Indexes
FA_DIMENSION_PKFA_DIMENSION_PK

Column Details

 FA_DIMENSION_ID
DescriptionThe unique identifier of the FA dimension
Data TypeINTEGER
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionName indicates the Full Name of the Financial Advisor
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 FA_DIMENSION_PK
DescriptionThe unique identifier of the FA dimension
MemberFA_DIMENSION_ID [INTEGER]

Index Details

 FA_DIMENSION_PK
DescriptionThe unique identifier of the FA dimension
Is Uniquetrue
Is Clusteredfalse
MemberFA_DIMENSION_ID [INTEGER] Ascending