DimProduct.ProductLine

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimProduct

Attribute DimProduct.ProductLine

Property NameValue
DescriptionProduct line
Display NameProductLine
ETL RulesDecode T=Touring, M=Mountain, R=Road, S=Accessory, NULL=Bike Part
Example ValuesMountain, Road, Touring
Is Audit Subsystem
SCD Type1
Source Datatypenchar(2)
Source Field NameProductLine
Source SchemaProduction
Source SystemAW
Source TableProduct
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: DimProduct