FactOrders.OrderInfoKey

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » FactOrders

Attribute FactOrders.OrderInfoKey

Property NameValue
CommentsWe've asked the trxn system folks to modify their application to capture a primary sales reason. Until then, we'll populate this with the first sales reason.
DescriptionKey to OrderInfo dimension
Display NameOrderInfoKey
Example Values1, 2, 3
Extraction/Transformation RulesKey lookup from SalesOrderHeaderSalesReason.SalesReasonID (first reason)
FK ToDimOrderInfo.OrderInfoKey
Is Audit Subsystem
Source SystemETL Process
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: FactOrders