MDWT_AdventureWorksDW.DimOrderInfo


Metadata hierarchy: MDWT_Adventure_Works_Demo ยป MDWT_AdventureWorksDW


Attributes in DimOrderInfo

Column NameData TypeIs KeyShort description
OrderInfoKeysmallintSurrogate primary key
BKSalesReasonIDsmallintSales reason ID from source system
ChannelcharSales channel
SalesReasonvarcharReason for the sale, as reported by the customer
SalesReasonTypecharType of sales reason
AuditKeyintWhat process loaded this row?

Internal data warehouse auditing attributes

Column NameData Type