dimension_table

dim_display_value

display value of the dimension

dim_description

description of the dimension

dim_type

a character value indicating the dimension type

T - time dimension

V - dimension view

D - dimension

C - slowly changing dimension

P - previous value dimension

else - unknown

column_name

column name

business_name

business name chosen for the column

description

description of the dimension column

data_type

data type of the dimension column

source_table

source table of the dimension table

source_column

source column of the dimension column

nulls_allowed

flag indicating whether or not nulls are allowed

numeric

flag indicating whether or not the column is numeric

additive

flag indicating whether or not the column is additive

attribute

flag indicating whether or not the column is an attribute

format

the dimension column format

column_order

the dimension column order