DimCustomer.FirstOrderDate

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer

Attribute DimCustomer.FirstOrderDate

Property NameValue
CommentsAfter load, look for 1st trxn for any dim rows where first_order_date is null (ongoing, should be today's load)
DescriptionDate store first ordered from us
Display NameFirstOrderDate
ETL RulesDerived from order trxns. Post-load update.
Is Audit Subsystem
SCD Type1
Source SystemDerived in ETL
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