DimCustomer.CustomerSalesTerritoryCountry

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer

Attribute DimCustomer.CustomerSalesTerritoryCountry

Property NameValue
CommentsWe may want to do this decoding in the ETL; copy CountryRegion to staging area?
DescriptionCustomer sales territory country
Display NameCustomerSalesTerritoryCountry
ETL RulesJoin from SalesTerritory to CountryRegion on CountryRegionCode
Is Audit Subsystem
SCD Type1
Source Datatypenvarchar(50)
Source Field NameName
Source SchemaPerson
Source SystemAW
Source TableCountryRegion
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