DimCustomer.CustomerType

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer

Attribute DimCustomer.CustomerType

Property NameValue
DescriptionThe type of the customer based on our relationship
Display NameCustomerType
ETL RulesDecode CustomerType from S/I to Reseller/Individual else Unknown
Example ValuesReseller, Individual
Is Audit Subsystem
SCD Type1
Source Field NameCustomerType
Source SchemaSales
Source SystemDerived in ETL
Source TableCustomer
Table Type
Used in schemas
View Name

Also Found In

  • A list tables where this item is also located can be found here.

    • More information about the source and ETL of this column can be found in:

  • Package: DimCustomer