DimCustomer.AddressLine1

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer

Attribute DimCustomer.AddressLine1

Property NameValue
DescriptionFirst line of customer's address
Display NameAddressLine1
ETL RulesJoin from Person.Contact on CustomerID; pick up the most recent address
Is Audit Subsystem
SCD Type1
Source Datatypenvarchar(60)
Source Field NameAddressLine1
Source SchemaSales
Source SystemAW
Source TableCustomerAddress
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