0% found this document useful (0 votes)

24 views100 pages

Adventure Works Work Book

The document outlines various business processes and their corresponding fact tables, detailing the granularity of data as one row per order or detail line item. It includes a comprehensive list of attributes related to sales, products, and employee information, along with their target systems and schemas for staging. The document serves as a reference for understanding the structure and organization of data within a business intelligence context.

Uploaded by

kecapew826

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

24 views100 pages

Adventure Works Work Book

Uploaded by

kecapew826

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

You are on page 1/ 100

Fact Type of

Business Process Fact Tables

Grain

Sales Overview FactFinance Transaction

FactInternetSales Transaction
FactResellerSales Transaction
FactCurrencyRate Transaction
Sales Agent FactSalesQuota Transaction
Product Inventory ProductInventory Transaction
Granularity Facts

One Row per order / detail line item refer: Dimensional Model (Attributes & Measures)
One Row per order / detail line item refer: Dimensional Model (Attributes & Measures)
One Row per order / detail line item refer: Dimensional Model (Attributes & Measures)
One Row per order / detail line item refer: Dimensional Model (Attributes & Measures)
One Row per order / detail line item refer: Dimensional Model (Attributes & Measures)
One Row per order / detail line item refer: Dimensional Model (Attributes & Measures)
Account

✔
✔
✔
✔
Currency

✔
✔ Customer

✔
✔
✔
✔
✔
✔

Date
✔

Department Group
✔
✔

Employee
✔
✔
✔

Geography
✔

Organization
✔
✔
✔
Product

✔
✔
✔
Product Category

✔
✔
✔ Product Sub Category

✔
✔
✔

Promotion
✔

Reseller
✔

Sales Reason
✔
✔
✔
✔

Sales Territory
High
High
High
High
High

Medium
Priority
Column Position Target System Target Schema
Department
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Employee
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
EmployeeDepartmentHistory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
EmployeePayHistory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
JobCandidate
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Shift
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Address
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
AddressType
MSS Staging
MSS Staging
MSS Staging
MSS Staging
BusinessEntity
MSS Staging
MSS Staging
MSS Staging
BusinessEntityAddress
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
BusinessEntityContact
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ContactType
MSS Staging
MSS Staging
MSS Staging
CountryRegion
MSS Staging
MSS Staging
MSS Staging
EmailAddress
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Password
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Person
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
PersonPhone
MSS Staging
MSS Staging
MSS Staging
MSS Staging
PhoneNumberType
MSS Staging
MSS Staging
MSS Staging
StateProvince
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
BillOfMaterials
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Culture
MSS Staging
MSS Staging
MSS Staging
Document
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Illustration
MSS Staging
MSS Staging
MSS Staging
Location
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Product
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductCategory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductCostHIstory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductDescription
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductDocument
MSS Staging
MSS Staging
MSS Staging
ProductInventory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductListHistory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductModel
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductModelIllustration
MSS Staging
MSS Staging
MSS Staging
ProductModelProductDescriptionCulture
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductPhoto
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductProductPhoto
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductReview
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductSubCategory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ScrapReason
MSS Staging
MSS Staging
MSS Staging
TransactionHistory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
TransactionHistoryArchive
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
UnitMeasure
MSS Staging
MSS Staging
MSS Staging
WorkOrder
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
WorkOrderRouting
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ProductVendor
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
PurchaseOrderDetail
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
PurchaseOrderHeader
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ShipMethod
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Vendor
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
CountryRegionCurrency
MSS Staging
MSS Staging
MSS Staging
CreditCard
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Currency
MSS Staging
MSS Staging
MSS Staging
CurrencyRate
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Customer
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
PersonCreditCard
MSS Staging
MSS Staging
MSS Staging
SalesOrderDetail
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesOrderHeader
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesOrderHeaderSalesReason
MSS Staging
MSS Staging
MSS Staging
SalesPerson
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesPersonQuotaHistory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesReason
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesTaxRate
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesTerritory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SalesTerritoryHistory
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
ShoppingCartItem
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SpecialOffer
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
SpecialOfferProduct
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Store
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
MSS Staging
Target(Staging)
Target Table Target Column Na

"Staging".Department DepartmentID
"Staging".Department Name
"Staging".Department GroupName
"Staging".Department ModifiedDate

"Staging".Employee BusinessEntityI
"Staging".Employee NationalIDNumb
"Staging".Employee LoginID
"Staging".Employee OrganizationNo
"Staging".Employee OrganizationLev
"Staging".Employee JobTitle
"Staging".Employee BirthDate
"Staging".Employee MaritalStatus
"Staging".Employee Gender
"Staging".Employee HireDate
"Staging".Employee SalariedFlag
"Staging".Employee VacationHours
"Staging".Employee SickLeaveHours
"Staging".Employee CurrentFlag
"Staging".Employee rowguid

"Staging".EmployeeDepartmentHistory BusinessEntityI
"Staging".EmployeeDepartmentHistory DepartmentID
"Staging".EmployeeDepartmentHistory ShiftID
"Staging".EmployeeDepartmentHistory StartDate
"Staging".EmployeeDepartmentHistory EndDate
"Staging".EmployeeDepartmentHistory ModifiedDate

"Staging".EmployeePayHistory BusinessEntityI
"Staging".EmployeePayHistory RateChangeDat
"Staging".EmployeePayHistory Rate
"Staging".EmployeePayHistory PayFrequency
"Staging".EmployeePayHistory ModifiedDate

"Staging".JobCandidate JobCandidateID
"Staging".JobCandidate BusinessEntityI
"Staging".JobCandidate Resume
"Staging".JobCandidate ModifiedDate

"Staging".Shift ShiftID
"Staging".Shift Name
"Staging".Shift StartTime
"Staging".Shift EndTime
"Staging".Shift ModifiedDate
"Staging".Address AddressID
"Staging".Address AddressLine1
"Staging".Address AddressLine2
"Staging".Address City
"Staging".Address StateProvinceID
"Staging".Address PostalCode
"Staging".Address SpatialLocation
"Staging".Address rowguid
"Staging".Address ModifiedDate

"Staging".AddressType AddressTypeID
"Staging".AddressType Name
"Staging".AddressType rowguid
"Staging".AddressType ModifiedDate

"Staging".BusinessEntity BusinessEntityI
"Staging".BusinessEntity rowguid
"Staging".BusinessEntity ModifiedDate

"Staging".BusinessEntityAddress BusinessEntityI
"Staging".BusinessEntityAddress AddressID
"Staging".BusinessEntityAddress AddressIDType
"Staging".BusinessEntityAddress rowguid
"Staging".BusinessEntityAddress ModifiedDate

"Staging".BusinessEntityContact BusinessEntityI
"Staging".BusinessEntityContact PersonID
"Staging".BusinessEntityContact ContactTypeID
"Staging".BusinessEntityContact rowguid
"Staging".BusinessEntityContact ModifiedDate

"Staging".ContactType ContactTypeID
"Staging".ContactType Name
"Staging".ContactType ModifiedDate

"Staging".CountryRegion CountryRegionC
"Staging".CountryRegion Name
"Staging".CountryRegion ModifiedDate

"Staging".EmailAddress BusinessEntityI
"Staging".EmailAddress EmailAddressID
"Staging".EmailAddress EmailAddressID
"Staging".EmailAddress rowguid
"Staging".EmailAddress ModifiedDate

"Staging".Password BusinessEntityI
"Staging".Password PasswordHash
"Staging".Password PasswordSalt
"Staging".Password rowguid
"Staging".Password ModifiedDate

"Staging".Person BusinessEntityI
"Staging".Person PersonType
"Staging".Person NameStyle
"Staging".Person Title
"Staging".Person FirstName
"Staging".Person MiddleName
"Staging".Person LastName
"Staging".Person Suffix
"Staging".Person EmailPromotion
"Staging".Person AdditionalContac
"Staging".Person Demographics
"Staging".Person rowguid
"Staging".Person ModifiedDate

"Staging".PersonPhone BusinessEntityI
"Staging".PersonPhone PhoneNumber
"Staging".PersonPhone PhoneNumberTy
"Staging".PersonPhone ModifiedDate

"Staging".PhoneNumberType PhoneNumberTy
"Staging".PhoneNumberType Name
"Staging".PhoneNumberType ModifiedDate

"Staging".StateProvince StateProvinceID
"Staging".StateProvince StateProvinceC
"Staging".StateProvince CountryRegionC
"Staging".StateProvince IsOnlyStateProv
"Staging".StateProvince Name
"Staging".StateProvince TerritotyID
"Staging".StateProvince rowguid
"Staging".StateProvince ModifiedDate

"Staging".BillOfMaterials BillOfMaterialsI
"Staging".BillOfMaterials ProductAssembl
"Staging".BillOfMaterials ComponentID
"Staging".BillOfMaterials StartDate
"Staging".BillOfMaterials EndDate
"Staging".BillOfMaterials UnitMeasureCod
"Staging".BillOfMaterials BOMLevel
"Staging".BillOfMaterials PerAssemblyQty
"Staging".BillOfMaterials ModifiedDate

"Staging".Culture CultureID
"Staging".Culture Name
"Staging".Culture ModifiedDate
"Staging".Document DocumentNode
"Staging".Document DocumentLevel
"Staging".Document Title
"Staging".Document Owner
"Staging".Document FolderFlag
"Staging".Document FileName
"Staging".Document FileExtension
"Staging".Document Revision
"Staging".Document ChangeNumber
"Staging".Document Status
"Staging".Document DocumentSumm
"Staging".Document Document
"Staging".Document rowguid
"Staging".Document ModifiedDate

"Staging".Illustration IllustrationID
"Staging".Illustration Diagram
"Staging".Illustration ModifiedDate

"Staging".Location LocationID
"Staging".Location Name
"Staging".Location CostRate
"Staging".Location Availability
"Staging".Location ModifiedDate

"Staging".Product ProductID
"Staging".Product Name
"Staging".Product MakeFlag
"Staging".Product FinishedGoodFl
"Staging".Product Color
"Staging".Product SafetyLockLevel
"Staging".Product ReorderPoint
"Staging".Product StandardCost
"Staging".Product ListPrice
"Staging".Product Size
"Staging".Product SizeUnitMeasur
"Staging".Product WeightUnitMeas
"Staging".Product Weight
"Staging".Product DaysToMnufactu
"Staging".Product ProductLine
"Staging".Product Class
"Staging".Product Style
"Staging".Product ProductSubCate
"Staging".Product SellStartDate
"Staging".Product SellEndDate
"Staging".Product DiscontinuedDa
"Staging".Product rowguid
"Staging".Product ModifiedDate

"Staging".ProductCategory ProductCategor
"Staging".ProductCategory Name
"Staging".ProductCategory rowguid
"Staging".ProductCategory ModifiedDate

"Staging".ProductCostHIstory ProductID
"Staging".ProductCostHIstory StartDate
"Staging".ProductCostHIstory EndDate
"Staging".ProductCostHIstory StandardCost
"Staging".ProductCostHIstory ModifiedDate

"Staging".ProductDescription ProductDescript
"Staging".ProductDescription Description
"Staging".ProductDescription rowguid
"Staging".ProductDescription ModifiedDate

"Staging".ProductDocument ProductID
"Staging".ProductDocument DocumentNode
"Staging".ProductDocument ModifiedDate

"Staging".ProductInventory ProductID
"Staging".ProductInventory LocationID
"Staging".ProductInventory Shelf
"Staging".ProductInventory Bin
"Staging".ProductInventory Quantity
"Staging".ProductInventory rowguid
"Staging".ProductInventory ModifiedDate

"Staging".ProductListHistory ProductID
"Staging".ProductListHistory StartDate
"Staging".ProductListHistory EndDate
"Staging".ProductListHistory ListPrice
"Staging".ProductListHistory ModifiedDate

"Staging".ProductModel ProductModelID
"Staging".ProductModel Name
"Staging".ProductModel CatalogDescript
"Staging".ProductModel Instructions
"Staging".ProductModel rowguid
"Staging".ProductModel ModifiedDate

"Staging".ProductModelIllustration ProductModelID
"Staging".ProductModelIllustration IllustrationID
"Staging".ProductModelIllustration ModifiedDate

"Staging".ProductModelProductDescriptionCulture ProductModelID
"Staging".ProductModelProductDescriptionCulture ProductDescript
"Staging".ProductModelProductDescriptionCulture CultureID
"Staging".ProductModelProductDescriptionCulture ModifiedDate

"Staging".ProductPhoto ProductPhotoID
"Staging".ProductPhoto ThumbNailPhoto
"Staging".ProductPhoto ThumbNailPhoto
"Staging".ProductPhoto LargePhoto
"Staging".ProductPhoto LargePhotoFile
"Staging".ProductPhoto ModifiedDate

"Staging".ProductProductPhoto ProductID
"Staging".ProductProductPhoto ProductPhotoID
"Staging".ProductProductPhoto Primary
"Staging".ProductProductPhoto ModifiedDate

"Staging".ProductReview ProductReviewI
"Staging".ProductReview ProductID
"Staging".ProductReview ReviewerName
"Staging".ProductReview EmailAddress
"Staging".ProductReview Rating
"Staging".ProductReview Comments
"Staging".ProductReview ModifiedDate

"Staging".ProductSubCategory ProductSubCate
"Staging".ProductSubCategory ProductCategor
"Staging".ProductSubCategory Name
"Staging".ProductSubCategory rowguid
"Staging".ProductSubCategory ModifiedDate

"Staging".ScrapReason ScrapReasonID
"Staging".ScrapReason Name
"Staging".ScrapReason ModifiedDate

"Staging".TransactionHistory TransactionID
"Staging".TransactionHistory ProductID
"Staging".TransactionHistory ReferenceOrder
"Staging".TransactionHistory ReferenceOrder
"Staging".TransactionHistory TransactionDate
"Staging".TransactionHistory TransactionTyp
"Staging".TransactionHistory Quantity
"Staging".TransactionHistory ActualCost
"Staging".TransactionHistory ModifiedDate

"Staging".TransactionHistoryArchive TransactionID
"Staging".TransactionHistoryArchive ProductID
"Staging".TransactionHistoryArchive ReferenceOrder
"Staging".TransactionHistoryArchive ReferenceOrder
"Staging".TransactionHistoryArchive TransactionDate
"Staging".TransactionHistoryArchive TransactionTyp
"Staging".TransactionHistoryArchive Quantity
"Staging".TransactionHistoryArchive ActualCost
"Staging".TransactionHistoryArchive ModifiedDate

"Staging".UnitMeasure UnitMeasureCod
"Staging".UnitMeasure Name
"Staging".UnitMeasure ModifiedDate

"Staging".WorkOrder WorkOrderID
"Staging".WorkOrder ProductID
"Staging".WorkOrder OrderQty
"Staging".WorkOrder ScrappedQty
"Staging".WorkOrder StartDate
"Staging".WorkOrder EndDate
"Staging".WorkOrder DueDate
"Staging".WorkOrder ScrapReasonID
"Staging".WorkOrder ModifiedDate

"Staging".WorkOrderRouting WorkOrderID
"Staging".WorkOrderRouting ProductID
"Staging".WorkOrderRouting OperationSeque
"Staging".WorkOrderRouting LocationID
"Staging".WorkOrderRouting ScheduledStart
"Staging".WorkOrderRouting ScheduledEndD
"Staging".WorkOrderRouting ActualStartDate
"Staging".WorkOrderRouting ActualEndDate
"Staging".WorkOrderRouting ActualResource
"Staging".WorkOrderRouting PlannedCost
"Staging".WorkOrderRouting ActualCost
"Staging".WorkOrderRouting ModifiedDate

"Staging".ProductVendor ProductID
"Staging".ProductVendor BusinessEntityI
"Staging".ProductVendor AverageLeadTi
"Staging".ProductVendor StandardPrice
"Staging".ProductVendor LastReceiptCost
"Staging".ProductVendor LastReceiptDate
"Staging".ProductVendor MinOrderQty
"Staging".ProductVendor MaxOrderQty
"Staging".ProductVendor OnOrderQty
"Staging".ProductVendor UnitMeasureCod
"Staging".ProductVendor ModifiedDate

"Staging".PurchaseOrderDetail PurchaseOrderI
"Staging".PurchaseOrderDetail PurchaseOrderDe
"Staging".PurchaseOrderDetail DueDate
"Staging".PurchaseOrderDetail OrderQty
"Staging".PurchaseOrderDetail ProductID
"Staging".PurchaseOrderDetail UnitPrice
"Staging".PurchaseOrderDetail LineTotal
"Staging".PurchaseOrderDetail ReceivedQty
"Staging".PurchaseOrderDetail RejectedQty
"Staging".PurchaseOrderDetail StockedQty
"Staging".PurchaseOrderDetail ModifiedDate

"Staging".PurchaseOrderHeader PurchaseOrderI
"Staging".PurchaseOrderHeader RevisionNumber
"Staging".PurchaseOrderHeader Status
"Staging".PurchaseOrderHeader EmployeeID
"Staging".PurchaseOrderHeader VendorID
"Staging".PurchaseOrderHeader ShipMethodID
"Staging".PurchaseOrderHeader OrderDate
"Staging".PurchaseOrderHeader ShipDate
"Staging".PurchaseOrderHeader SubTotal
"Staging".PurchaseOrderHeader TaxAmt
"Staging".PurchaseOrderHeader Freight
"Staging".PurchaseOrderHeader TotalDue
"Staging".PurchaseOrderHeader ModifiedDate

"Staging".ShipMethod ShipMethodID
"Staging".ShipMethod Name
"Staging".ShipMethod ShipBase
"Staging".ShipMethod ShipRate
"Staging".ShipMethod rowguid
"Staging".ShipMethod ModifiedDate

"Staging".Vendor BusinessEntityI
"Staging".Vendor AccountNumber
"Staging".Vendor Name
"Staging".Vendor CreditRating
"Staging".Vendor PreferredVendor
"Staging".Vendor ActiveFlag
"Staging".Vendor PurchasingWebS
"Staging".Vendor ModifiedDate

"Staging".CountryRegionCurrency CountryRegionC
"Staging".CountryRegionCurrency CurrencyCode
"Staging".CountryRegionCurrency ModifiedDate

"Staging".CreditCard CreditCardID
"Staging".CreditCard CardType
"Staging".CreditCard CardNumber
"Staging".CreditCard ExpMonth
"Staging".CreditCard ExpYear
"Staging".CreditCard ModifiedDate

"Staging".Currency CurrencyCode
"Staging".Currency Name
"Staging".Currency ModifiedDate

"Staging".CurrencyRate CurrencyRateID
"Staging".CurrencyRate CurrencyRateDa
"Staging".CurrencyRate FromCurrencyC
"Staging".CurrencyRate ToCurrencyCode
"Staging".CurrencyRate AverageRate
"Staging".CurrencyRate EndOfDayRate
"Staging".CurrencyRate ModifiedDate

"Staging".Customer CustomerID
"Staging".Customer PersonID
"Staging".Customer StoreID
"Staging".Customer TerritotyID
"Staging".Customer AccountNumber
"Staging".Customer rowguid
"Staging".Customer ModifiedDate

"Staging".PersonCreditCard BusinessEntityI
"Staging".PersonCreditCard CreditCard
"Staging".PersonCreditCard ModifiedDate

"Staging".SalesOrderDetail SalesOrderID
"Staging".SalesOrderDetail SalesOrderDetai
"Staging".SalesOrderDetail CarrierTrackin
"Staging".SalesOrderDetail OrderQty
"Staging".SalesOrderDetail ProductID
"Staging".SalesOrderDetail SpecialOfferID
"Staging".SalesOrderDetail UnitPrice
"Staging".SalesOrderDetail UnitPriceDiscou
"Staging".SalesOrderDetail LineTotal
"Staging".SalesOrderDetail rowguid
"Staging".SalesOrderDetail ModifiedDate

"Staging".SalesOrderHeader SalesOrderID
"Staging".SalesOrderHeader RevisionNumber
"Staging".SalesOrderHeader OrderDate
"Staging".SalesOrderHeader DueDate
"Staging".SalesOrderHeader ShipDate
"Staging".SalesOrderHeader Status
"Staging".SalesOrderHeader OnlineOrderFlag
"Staging".SalesOrderHeader SalesOrderNum
"Staging".SalesOrderHeader PurchaseOrder
"Staging".SalesOrderHeader AccountNumber
"Staging".SalesOrderHeader CustomerID
"Staging".SalesOrderHeader SalesPersonID
"Staging".SalesOrderHeader TerritotyID
"Staging".SalesOrderHeader BillToAddressID
"Staging".SalesOrderHeader ShipToAddressI
"Staging".SalesOrderHeader ShipMethodID
"Staging".SalesOrderHeader CreditCardID
"Staging".SalesOrderHeader CreditCardAppr
"Staging".SalesOrderHeader CurrencyRateID
"Staging".SalesOrderHeader SubTotal
"Staging".SalesOrderHeader TaxAmt
"Staging".SalesOrderHeader Freight
"Staging".SalesOrderHeader TotalDue
"Staging".SalesOrderHeader Comment
"Staging".SalesOrderHeader rowguid
"Staging".SalesOrderHeader ModifiedDate

"Staging".SalesOrderHeaderSalesReason SalesOrderID
"Staging".SalesOrderHeaderSalesReason SalesReasonID
"Staging".SalesOrderHeaderSalesReason ModifiedDate

"Staging".SalesPerson BusinessEntityI
"Staging".SalesPerson TerritoryID
"Staging".SalesPerson SalesQuota
"Staging".SalesPerson Bonus
"Staging".SalesPerson CommissionPct
"Staging".SalesPerson SalesYTD
"Staging".SalesPerson SalesLastYear
"Staging".SalesPerson rowguid
"Staging".SalesPerson ModifiedDate

"Staging".SalesPersonQuotaHistory BusinessEntityI
"Staging".SalesPersonQuotaHistory QuotaDate
"Staging".SalesPersonQuotaHistory SalesQuota
"Staging".SalesPersonQuotaHistory rowguid
"Staging".SalesPersonQuotaHistory ModifiedDate

"Staging".SalesReason SalesReasonID
"Staging".SalesReason Name
"Staging".SalesReason ReasonType
"Staging".SalesReason ModifiedDate

"Staging".SalesTaxRate SalesTaxRateID
"Staging".SalesTaxRate StateProvinceID
"Staging".SalesTaxRate TaxType
"Staging".SalesTaxRate TaxRate
"Staging".SalesTaxRate Name
"Staging".SalesTaxRate rowguid
"Staging".SalesTaxRate ModifiedDate

"Staging".SalesTerritory TerritotyID
"Staging".SalesTerritory Name
"Staging".SalesTerritory CounrtyRegionC
"Staging".SalesTerritory Group
"Staging".SalesTerritory SalesYTD
"Staging".SalesTerritory SalesLastYear
"Staging".SalesTerritory CostYTD
"Staging".SalesTerritory CostLastYear
"Staging".SalesTerritory rowguid
"Staging".SalesTerritory ModifiedDate

"Staging".SalesTerritoryHistory BusinessEntityI
"Staging".SalesTerritoryHistory TerritotyID
"Staging".SalesTerritoryHistory StartDate
"Staging".SalesTerritoryHistory EndDate
"Staging".SalesTerritoryHistory rowguid
"Staging".SalesTerritoryHistory ModifiedDate

"Staging".ShoppingCartItem ShoppingCartIt
"Staging".ShoppingCartItem ShoppingCartID
"Staging".ShoppingCartItem Quantity
"Staging".ShoppingCartItem ProductID
"Staging".ShoppingCartItem DateCreated
"Staging".ShoppingCartItem ModifiedDate

int MSS Sales
uniqueidentifier MSS Sales
datetime MSS Sales

int PK MSS Sales

nvarchar(50) MSS Sales
int MSS Sales
xml MSS Sales
uniqueidentifier MSS Sales
datetime MSS Sales
Source(Data Lake)
Souce Table Source Column Name

Department DepartmentID
Department Name
Department GroupName
Department ModifiedDate

Employee BusinessEntityID
Employee NationalIDNumber
Employee LoginID
Employee OrganizationNode
Employee OrganizationLevel
Employee JobTitle
Employee BirthDate
Employee MaritalStatus
Employee Gender
Employee HireDate
Employee SalariedFlag
Employee VacationHours
Employee SickLeaveHours
Employee CurrentFlag
Employee rowguid

EmployeeDepartmentHistory BusinessEntityID
EmployeeDepartmentHistory DepartmentID
EmployeeDepartmentHistory ShiftID
EmployeeDepartmentHistory StartDate
EmployeeDepartmentHistory EndDate
EmployeeDepartmentHistory ModifiedDate

EmployeePayHistory BusinessEntityID
EmployeePayHistory RateChangeDate
EmployeePayHistory Rate
EmployeePayHistory PayFrequency
EmployeePayHistory ModifiedDate

JobCandidate JobCandidateID
JobCandidate BusinessEntityID
JobCandidate Resume
JobCandidate ModifiedDate

Shift ShiftID
Shift Name
Shift StartTime
Shift EndTime
Shift ModifiedDate
Address AddressID
Address AddressLine1
Address AddressLine2
Address City
Address StateProvinceID
Address PostalCode
Address SpatialLocation
Address rowguid
Address ModifiedDate

AddressType AddressTypeID
AddressType Name
AddressType rowguid
AddressType ModifiedDate

BusinessEntity BusinessEntityID
BusinessEntity rowguid
BusinessEntity ModifiedDate

BusinessEntityAddress BusinessEntityID
BusinessEntityAddress AddressID
BusinessEntityAddress AddressIDType
BusinessEntityAddress rowguid
BusinessEntityAddress ModifiedDate

BusinessEntityContact BusinessEntityID
BusinessEntityContact PersonID
BusinessEntityContact ContactTypeID
BusinessEntityContact rowguid
BusinessEntityContact ModifiedDate

ContactType ContactTypeID
ContactType Name
ContactType ModifiedDate

CountryRegion CountryRegionCode
CountryRegion Name
CountryRegion ModifiedDate

EmailAddress BusinessEntityID
EmailAddress EmailAddressID
EmailAddress EmailAddressID
EmailAddress rowguid
EmailAddress ModifiedDate

Password BusinessEntityID
Password PasswordHash
Password PasswordSalt
Password rowguid
Password ModifiedDate

Person BusinessEntityID
Person PersonType
Person NameStyle
Person Title
Person FirstName
Person MiddleName
Person LastName
Person Suffix
Person EmailPromotion
Person AdditionalContactInfo
Person Demographics
Person rowguid
Person ModifiedDate

PersonPhone BusinessEntityID
PersonPhone PhoneNumber
PersonPhone PhoneNumberTypeID
PersonPhone ModifiedDate

PhoneNumberType PhoneNumberTypeID
PhoneNumberType Name
PhoneNumberType ModifiedDate

StateProvince StateProvinceID
StateProvince StateProvinceCode
StateProvince CountryRegionCode
StateProvince IsOnlyStateProvinceFlag
StateProvince Name
StateProvince TerritotyID
StateProvince rowguid
StateProvince ModifiedDate

BillOfMaterials BillOfMaterialsID
BillOfMaterials ProductAssemblyID
BillOfMaterials ComponentID
BillOfMaterials StartDate
BillOfMaterials EndDate
BillOfMaterials UnitMeasureCode
BillOfMaterials BOMLevel
BillOfMaterials PerAssemblyQty
BillOfMaterials ModifiedDate

Culture CultureID
Culture Name
Culture ModifiedDate
Document DocumentNode
Document DocumentLevel
Document Title
Document Owner
Document FolderFlag
Document FileName
Document FileExtension
Document Revision
Document ChangeNumber
Document Status
Document DocumentSummary
Document Document
Document rowguid
Document ModifiedDate

Illustration IllustrationID
Illustration Diagram
Illustration ModifiedDate

Location LocationID
Location Name
Location CostRate
Location Availability
Location ModifiedDate

Product ProductID
Product Name
Product MakeFlag
Product FinishedGoodFlag
Product Color
Product SafetyLockLevel
Product ReorderPoint
Product StandardCost
Product ListPrice
Product Size
Product SizeUnitMeasureCode
Product WeightUnitMeasureCode
Product Weight
Product DaysToMnufacture
Product ProductLine
Product Class
Product Style
Product ProductSubCategoryID
Product SellStartDate
Product SellEndDate
Product DiscontinuedDate
Product rowguid
Product ModifiedDate

ProductCategory ProductCategoryID
ProductCategory Name
ProductCategory rowguid
ProductCategory ModifiedDate

ProductCostHIstory ProductID
ProductCostHIstory StartDate
ProductCostHIstory EndDate
ProductCostHIstory StandardCost
ProductCostHIstory ModifiedDate

ProductDescription ProductDescriptionID
ProductDescription Description
ProductDescription rowguid
ProductDescription ModifiedDate

ProductDocument ProductID
ProductDocument DocumentNode
ProductDocument ModifiedDate

ProductInventory ProductID
ProductInventory LocationID
ProductInventory Shelf
ProductInventory Bin
ProductInventory Quantity
ProductInventory rowguid
ProductInventory ModifiedDate

ProductListHistory ProductID
ProductListHistory StartDate
ProductListHistory EndDate
ProductListHistory ListPrice
ProductListHistory ModifiedDate

ProductModel ProductModelID
ProductModel Name
ProductModel CatalogDescription
ProductModel Instructions
ProductModel rowguid
ProductModel ModifiedDate

ProductModelIllustration ProductModelID
ProductModelIllustration IllustrationID
ProductModelIllustration ModifiedDate

ProductModelProductDescriptionCulture ProductModelID
ProductModelProductDescriptionCulture ProductDescriptionID
ProductModelProductDescriptionCulture CultureID
ProductModelProductDescriptionCulture ModifiedDate

ProductPhoto ProductPhotoID
ProductPhoto ThumbNailPhoto
ProductPhoto ThumbNailPhotoFileName
ProductPhoto LargePhoto
ProductPhoto LargePhotoFileName
ProductPhoto ModifiedDate

ProductProductPhoto ProductID
ProductProductPhoto ProductPhotoID
ProductProductPhoto Primary
ProductProductPhoto ModifiedDate

ProductReview ProductReviewID
ProductReview ProductID
ProductReview ReviewerName
ProductReview EmailAddress
ProductReview Rating
ProductReview Comments
ProductReview ModifiedDate

ProductSubCategory ProductSubCategoryID
ProductSubCategory ProductCategoryID
ProductSubCategory Name
ProductSubCategory rowguid
ProductSubCategory ModifiedDate

ScrapReason ScrapReasonID
ScrapReason Name
ScrapReason ModifiedDate

TransactionHistory TransactionID
TransactionHistory ProductID
TransactionHistory ReferenceOrderID
TransactionHistory ReferenceOrderLineID
TransactionHistory TransactionDate
TransactionHistory TransactionType
TransactionHistory Quantity
TransactionHistory ActualCost
TransactionHistory ModifiedDate

TransactionHistoryArchive TransactionID
TransactionHistoryArchive ProductID
TransactionHistoryArchive ReferenceOrderID
TransactionHistoryArchive ReferenceOrderLineID
TransactionHistoryArchive TransactionDate
TransactionHistoryArchive TransactionType
TransactionHistoryArchive Quantity
TransactionHistoryArchive ActualCost
TransactionHistoryArchive ModifiedDate

UnitMeasure UnitMeasureCode
UnitMeasure Name
UnitMeasure ModifiedDate

WorkOrder WorkOrderID
WorkOrder ProductID
WorkOrder OrderQty
WorkOrder ScrappedQty
WorkOrder StartDate
WorkOrder EndDate
WorkOrder DueDate
WorkOrder ScrapReasonID
WorkOrder ModifiedDate

WorkOrderRouting WorkOrderID
WorkOrderRouting ProductID
WorkOrderRouting OperationSequence
WorkOrderRouting LocationID
WorkOrderRouting ScheduledStartDate
WorkOrderRouting ScheduledEndDate
WorkOrderRouting ActualStartDate
WorkOrderRouting ActualEndDate
WorkOrderRouting ActualResourceHrs
WorkOrderRouting PlannedCost
WorkOrderRouting ActualCost
WorkOrderRouting ModifiedDate

ProductVendor ProductID
ProductVendor BusinessEntityID
ProductVendor AverageLeadTime
ProductVendor StandardPrice
ProductVendor LastReceiptCost
ProductVendor LastReceiptDate
ProductVendor MinOrderQty
ProductVendor MaxOrderQty
ProductVendor OnOrderQty
ProductVendor UnitMeasureCode
ProductVendor ModifiedDate

PurchaseOrderDetail PurchaseOrderID
PurchaseOrderDetail PurchaseOrderDetailID
PurchaseOrderDetail DueDate
PurchaseOrderDetail OrderQty
PurchaseOrderDetail ProductID
PurchaseOrderDetail UnitPrice
PurchaseOrderDetail LineTotal
PurchaseOrderDetail ReceivedQty
PurchaseOrderDetail RejectedQty
PurchaseOrderDetail StockedQty
PurchaseOrderDetail ModifiedDate

PurchaseOrderHeader PurchaseOrderID
PurchaseOrderHeader RevisionNumber
PurchaseOrderHeader Status
PurchaseOrderHeader EmployeeID
PurchaseOrderHeader VendorID
PurchaseOrderHeader ShipMethodID
PurchaseOrderHeader OrderDate
PurchaseOrderHeader ShipDate
PurchaseOrderHeader SubTotal
PurchaseOrderHeader TaxAmt
PurchaseOrderHeader Freight
PurchaseOrderHeader TotalDue
PurchaseOrderHeader ModifiedDate

ShipMethod ShipMethodID
ShipMethod Name
ShipMethod ShipBase
ShipMethod ShipRate
ShipMethod rowguid
ShipMethod ModifiedDate

Vendor BusinessEntityID
Vendor AccountNumber
Vendor Name
Vendor CreditRating
Vendor PreferredVendorStatus
Vendor ActiveFlag
Vendor PurchasingWebServiceURL
Vendor ModifiedDate

CountryRegionCurrency CountryRegionCode
CountryRegionCurrency CurrencyCode
CountryRegionCurrency ModifiedDate

CreditCard CreditCardID
CreditCard CardType
CreditCard CardNumber
CreditCard ExpMonth
CreditCard ExpYear
CreditCard ModifiedDate

Currency CurrencyCode
Currency Name
Currency ModifiedDate

CurrencyRate CurrencyRateID
CurrencyRate CurrencyRateDate
CurrencyRate FromCurrencyCode
CurrencyRate ToCurrencyCode
CurrencyRate AverageRate
CurrencyRate EndOfDayRate
CurrencyRate ModifiedDate

Customer CustomerID
Customer PersonID
Customer StoreID
Customer TerritotyID
Customer AccountNumber
Customer rowguid
Customer ModifiedDate

PersonCreditCard BusinessEntityID
PersonCreditCard CreditCard
PersonCreditCard ModifiedDate

SalesOrderDetail SalesOrderID
SalesOrderDetail SalesOrderDetail
SalesOrderDetail CarrierTrackingNumber
SalesOrderDetail OrderQty
SalesOrderDetail ProductID
SalesOrderDetail SpecialOfferID
SalesOrderDetail UnitPrice
SalesOrderDetail UnitPriceDiscount
SalesOrderDetail LineTotal
SalesOrderDetail rowguid
SalesOrderDetail ModifiedDate

SalesOrderHeader SalesOrderID
SalesOrderHeader RevisionNumber
SalesOrderHeader OrderDate
SalesOrderHeader DueDate
SalesOrderHeader ShipDate
SalesOrderHeader Status
SalesOrderHeader OnlineOrderFlag
SalesOrderHeader SalesOrderNumber
SalesOrderHeader PurchaseOrderNumber
SalesOrderHeader AccountNumber
SalesOrderHeader CustomerID
SalesOrderHeader SalesPersonID
SalesOrderHeader TerritotyID
SalesOrderHeader BillToAddressID
SalesOrderHeader ShipToAddressID
SalesOrderHeader ShipMethodID
SalesOrderHeader CreditCardID
SalesOrderHeader CreditCardApprovalCode
SalesOrderHeader CurrencyRateID
SalesOrderHeader SubTotal
SalesOrderHeader TaxAmt
SalesOrderHeader Freight
SalesOrderHeader TotalDue
SalesOrderHeader Comment
SalesOrderHeader rowguid
SalesOrderHeader ModifiedDate

SalesOrderHeaderSalesReason SalesOrderID
SalesOrderHeaderSalesReason SalesReasonID
SalesOrderHeaderSalesReason ModifiedDate

SalesPerson BusinessEntityID
SalesPerson TerritoryID
SalesPerson SalesQuota
SalesPerson Bonus
SalesPerson CommissionPct
SalesPerson SalesYTD
SalesPerson SalesLastYear
SalesPerson rowguid
SalesPerson ModifiedDate

SalesPersonQuotaHistory BusinessEntityID
SalesPersonQuotaHistory QuotaDate
SalesPersonQuotaHistory SalesQuota
SalesPersonQuotaHistory rowguid
SalesPersonQuotaHistory ModifiedDate

SalesReason SalesReasonID
SalesReason Name
SalesReason ReasonType
SalesReason ModifiedDate

SalesTaxRate SalesTaxRateID
SalesTaxRate StateProvinceID
SalesTaxRate TaxType
SalesTaxRate TaxRate
SalesTaxRate Name
SalesTaxRate rowguid
SalesTaxRate ModifiedDate

SalesTerritory TerritotyID
SalesTerritory Name
SalesTerritory CounrtyRegionCode
SalesTerritory Group
SalesTerritory SalesYTD
SalesTerritory SalesLastYear
SalesTerritory CostYTD
SalesTerritory CostLastYear
SalesTerritory rowguid
SalesTerritory ModifiedDate

SalesTerritoryHistory BusinessEntityID
SalesTerritoryHistory TerritotyID
SalesTerritoryHistory StartDate
SalesTerritoryHistory EndDate
SalesTerritoryHistory rowguid
SalesTerritoryHistory ModifiedDate

ShoppingCartItem ShoppingCartItemID
ShoppingCartItem ShoppingCartID
ShoppingCartItem Quantity
ShoppingCartItem ProductID
ShoppingCartItem DateCreated
ShoppingCartItem ModifiedDate

SpecialOffer SpecialOfferID
SpecialOffer Description
SpecialOffer DiscountPct
SpecialOffer Type
SpecialOffer Category
SpecialOffer StartDate
SpecialOffer EndDate
SpecialOffer MinQty
SpecialOffer MaxQty
SpecialOffer rowguid
SpecialOffer ModifiedDate

SpecialOfferProduct SpecialOfferProductID
SpecialOfferProduct ProductID
SpecialOfferProduct rowguid
SpecialOfferProduct ModifiedDate

Store StoreBusinessEntityID
Store Name
Store SalesPersonID
Store Demographics
Store rowguid
Store ModifiedDate
Source Data Type Comment

smallint PK
nvarchar(50)
nvarchar(50)
datetime

int PK
nvarchar(15)
nvarchar(256)
hierarchyid
smallint
nvarchar(50)
date
nchar(1)
nchar(1)
date
bit
smallint
smallint
bit
uniqueidentifier

int PK
smallint
tinyint
date
date
datetime

int PK
datetime
money
tinyint
datetime

int PK
int
xml
datetime

tinyiny PK
nvarchar(50)
time(7)
time(7)
datetime
int PK
nvarchar(60)
nvarchar(60)
nvarchar(30)
int
nvarchar(15)
geography
uniqueidentifier
datetime

int PK
nvarchar(50)
uniqueidentifier
datetime

int PK
uniqueidentifier
datetime

int PK
int
int
uniqueidentifier
datetime

int PK
nvarchar(50)
datetime

nvarchar(3) PK
nvarchar(50)
datetime

int PK
int
nvarchar(50)
uniqueidentifier
datetime

int PK
varchar(128)
varchar(10)
uniqueidentifier
datetime

int PK
nchar(2)
bit
nvarchar(8)
nvarchar(50)
nvarchar(50)
nvarchar(50)
nvarchar(10)
int
xml
xml
uniqueidentifier
datetime

int PK
nvarchar(25)
int
datetime

int PK
nvarchar(50)
datetime

int
nvchar(3)
nvarchar(3)
bit
nvarchar(50)
int
uniqueidentifier
datetime

int
int
int
datetime
datetime
nchar(3)
smallint
decimal(8,2)
datetime

nchar(6)
nvarchar(50)
datetime
hierarchyid PK
smallint
nvarchar(50)
int
bit
nvarchar(400)
nvarchar(8)
nchar(5)
int
tinyint
nvarchar(MAX)
varbinary(MAX)
uniqueidentifier
datetime

int PK
xml
datetime

smallint PK
nvarchar(50)
smallmoney
decimal(8,2)
datetime

int PK
nvarchar(50)
bit
bit
nvarchar(15)
smallint
smallint
money
money
nvarchar(5)
nchar(3)
nchar(3)
decimal(8,2)
int
nchar(2)
nchar(2)
nchar(2)
int
datetime
datetime
datetime
uniqueidentifier
datetime

int PK
nvarchar(50)
uniqueidentifier
datetime

int PK
datetime
datetime
money
datetime

int PK
nvarchar(400)
uniqueidentifier
datetime

int PK
hierarchyid
datetime

int PK
smallint
nvarchar(10)
tinyint
smallint
uniqueidentifier
datetime

int PK
datetime
datetime
money
datetime

int PK
nvarchar(50)
xml
xml
uniqueidentifier
datetime

int PK
int
datetime

int PK
int
nchar(6)
datetime

int PK
varbinary(MAX)
nvarchar(50)
varbinary(MAX)
nvarchar(50)
datetime

int PK
int
bit
datetime

int PK
int
nvarchar(50)
nvarchar(50)
int
nvarchar(3850)
datetime

int PK
int
nvarchar(50)
uniqueidentifier
datetime

smallint PK
nvarchar(50)
datetime

int PK
int
int
int
datetime
nchar(1)
int
money
datetime

nchar(3) PK
nvarchar(50)
datetime

int PK
int
int
smallint
datetime
datetime
datetime
smallint
datetime

int PK
int
smallint
smallint
datetime
datetime
datetime
datetime
decimal(9,4)
money
money
datetime

int PK
int
int
money
money
datetime
int
int
int
nchar(3)
datetime

int PK
int
datetime
int
int
money
money
decimal(8,2)
decimal(8,2)
decimal(9,2)
datetime

int PK
tinyint
tinyint
int
int
int
datetime
datetime
money
money
money
money
datetime

int PK
nvarchar(50)
money
money
uniqueidentifier
datetime

int PK
nvarchar(15)
nvarchar(50)
tinyint
bit
bit
nvarchar(1024)
datetime

nvarchar(3) PK
nchar(3)
datetime

int PK
nvarchar(50)
nvarchar(25)
tinyint
smallint
datetime

nchar(3) PK
nvarchar(50)
datetime

int PK
datetime
nchar(3)
nchar(3)
money
money
datetime

int PK
int
int
int
varchar(10)
uniqueidentifier
datetime

int PK
int
datetime

int PK
int
nvarchar(25)
smallint
int
int
money
money
numeric
uniqueidentifier
datetime

int PK
tinyint
datetime
datetime
datetime
tinyint
bit
nvarchar(23)
nvarchar(25)
nvarchar(15)
int
int
int
int
int
int
int
varchar(15)
int
money
money
money
money
nvarchar(128)
uniqueidentifier
datetime

int PK
int
datetime

int PK
int
money
money
smallmoney
money
money
uniqueidentifier
datetime

int PK
datetime
money
uniqueidentifier
datetime

int PK
nvarchar(50)
nvarchar(50)
datetime

int PK
int
tinyint
smallmoney
nvarchar(50)
uniqueidentifier
datetime

int PK
nvarchar(50)
nvarchar(3)
nvarchar(50)
money
money
money
money
uniqueidentifier
datetime

int PK
int
datetime
datetime
uniqueidentifier
datetime

int PK
int
int
int
datetime
datetime

int PK
nvarchar(255)
smallmoney
nvarchar(50)
nvarchar(50)
datetime
datetime
int
int
uniqueidentifier
datetime

int PK
int
uniqueidentifier
datetime

int PK
nvarchar(50)
int
xml
uniqueidentifier
datetime
Target (Dimensional Data Wareho
Column Position Target System Target Schema Target Table

MSS dbo DimAccount

MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimAccount
MSS dbo DimCurrency
MSS dbo DimCurrency
MSS dbo DimCurrency
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimCustomer
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDate
MSS dbo DimDepartmentGroup
MSS dbo DimDepartmentGroup
MSS dbo DimDepartmentGroup
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimEmployee
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimGeography
MSS dbo DimOrganization
MSS dbo DimOrganization
MSS dbo DimOrganization
MSS dbo DimOrganization
MSS dbo DimOrganization
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProduct
MSS dbo DimProductCategory
MSS dbo DimProductCategory
MSS dbo DimProductCategory
MSS dbo DimProductCategory
MSS dbo DimProductCategory
MSS dbo DimProductSubCategory
MSS dbo DimProductSubCategory
MSS dbo DimProductSubCategory
MSS dbo DimProductSubCategory
MSS dbo DimProductSubCategory
MSS dbo DimProductSubCategory
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimPromotion
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimReseller
MSS dbo DimSalesReason
MSS dbo DimSalesReason
MSS dbo DimSalesReason
MSS dbo DimSalesReason
MSS dbo DimSalesTerritory
MSS dbo DimSalesTerritory
MSS dbo DimSalesTerritory
MSS dbo DimSalesTerritory
MSS dbo DimSalesTerritory
MSS dbo DimSalesTerritory
MSS dbo FactCurrencyRate
MSS dbo FactCurrencyRate
MSS dbo FactCurrencyRate
MSS dbo FactCurrencyRate
MSS dbo FactCurrencyRate
MSS dbo FactFinance
MSS dbo FactFinance
MSS dbo FactFinance
MSS dbo FactFinance
MSS dbo FactFinance
MSS dbo FactFinance
MSS dbo FactFinance
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSales
MSS dbo FactInternetSalesReason
MSS dbo FactInternetSalesReason
MSS dbo FactInternetSalesReason
MSS dbo FactProductInventory
MSS dbo FactProductInventory
MSS dbo FactProductInventory
MSS dbo FactProductInventory
MSS dbo FactProductInventory
MSS dbo FactProductInventory
MSS dbo FactProductInventory
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactResellersSales
MSS dbo FactSalesQuota
MSS dbo FactSalesQuota
MSS dbo FactSalesQuota
MSS dbo FactSalesQuota
MSS dbo FactSalesQuota
MSS dbo FactSalesQuota
MSS dbo FactSalesQuota
Dimensional Data Warehouse)
Target Column Name Target Data Type

AccountKey int PK
ParentAccountKey int
AccountCodeAlternateKey int
ParentAccountCodeAlternateKey int
AccountDescription nvarchar(50)
AccountType nvarchar(50)
Operator nvarchar(50)
CustomMembers nvarchar(300)
ValueType nvarchar(50)
CustomMembersOptions nvarchar(200)
CurrencyKey int PK
CurrencyAlternateKey int FK
CurrencyName
CustomerKey int PK
CustomerAlternateKey nvarchar(15) FK
GeographyKey int
Title nvarchar(8)
FirstName nvarchar(50)
MiddleName nvarchar(50)
LastName nvarchar(50)
NameStyle bit
BirthDate date
MaritalStatus nchar(1)
Suffix nvarchar(10)
Gender nvarchar(1)
EmailAddress nvarchar(50)
YearlyIncome money
TotalChildren tinyint
NumberChildrenAtHome tinyint
EnglishEducation nvarchar(40)
SpanishEducation nvarchar(40)
FrenchEducation nvarchar(40)
EnglishOccupation nvarchar(100)
SpanishOccupation nvarchar(100)
FrenchOccupation nvarchar(100)
HouseOwnerFlag nchar(1)
NumbeCarsOwned tinyint
AddressLine1 nvarchar(120)
AddressLine2 nvarchar(120)
Phone nvarchar(20)
DateFirstPurchase date
CommuteDistance nvarchar(15)
DateKey int PK
FullDateAlternateKey date FK
DayNumberOfWeek tinyint
EnglishDayNumberOfWeek nvarchar(10)
SpanishDayNumberOfWeek nvarchar(10)
FrenchDayNumberOfWeek nvarchar(10)
DayNumberOfMonth tinyint
DayNumberOfYear smallint
WeekNumberOfYear tinyint
EnglishMonthName nvarchar(10)
SpanishMonthName nvarchar(10)
FrenchMonthName nvarchar(10)
MonthNumberOfYear tinyint
CalenderQuarter tinyint
CalenderYear smallint
CalenderSemester tinyint
FiscalQuarter tinyint
FiscalYear smallint
FiscalSemester tinyint
DepartmentGroupKey int PK
ParentDepartmentGroupKey int
DepartmentGroupName nvarchar(50)
EmployeeKey int PK
ParentEmployeeKey int
EmployeeNationalIDAlternateKey nvarchar(15)
ParentEmployeeNationalIDAlternateKey nvarchar(15)
SalesTerritoryKey int
FirstName nvarchar(50)
LastName nvarchar(50)
MiddleName nvarchar(50)
NameStyle bit
Title nvarchar(50)
HireDate date
BirthDate date
LoginID nvarchar(25)
EmailAddress nvarchar(50)
Phone nvarchar(25)
MaritalStatus nchar(1)
EmergencyContactName nvarchar(50)
EmergencyContactPhone nvarchar(25)
SalariedFlag bit
Gender nchar(1)
PayFrequency tinyint
BaseRate money
VacationHours smallint
SickLeaveHours smallint
CurrentFlag bit
SalesPersonFlag bit
DepartmentName nvarchar(50)
StartDate date
EndDate date
Status nvarchar(50)
EmployeePhoto varbinary(MAX)
GeographyKey int PK
City nvarchar(50)
StateProvinceCode nvarchar(3)
StateProvinceName nvarchar(50)
CountryRegionCode nvarchar(3)
EnglishCountryRegionCode nvarchar(50)
SpanishCountryRegionCode nvarchar(50)
FrenchCountryRegionCode nvarchar(50)
PostalCode nvarchar(15)
SalesTerritoryKey int
IpAdressLocatort nvarchar(15)
OrganizationKey int PK
ParentOrganizationKey int
PercentageOwnership nvarchar(16)
OrganizationName nvarchar(50)
CurrencyKey int PK
ProductAlternateKey int
ProductSubCategoryKey int
WeightUnitMeasureCode nchar(3)
SizeUnitMeasureCode nchar(3)
EnglishProductName nvarchar(50)
SpanishProductName nvarchar(50)
FrenchProductName nvarchar(50)
StandardCost money
FinishedGoodsFlag bit
Color nvarchar(15)
SafetyStockLevel smallint
ReorderPoint smallint
ListPrice money
Size nvarchar(50)
SizeRange nvarchar(50)
Weight float
DaysToManufacture int
ProductLine nchar(2)
DealerPrice money
Class nchar(2)
Style nchar(2)
ModelName nvarchar(50)
LargePhoto varbinary(MAX)
EnglishDescription nvarchar(400)
ChineseDescription nvarchar(400)
FrenchDescription nvarchar(400)
ArabicDescription nvarchar(400)
HebrewDescription nvarchar(400)
ThaiDescription nvarchar(400)
GermanDescription nvarchar(400)
JapaneseDescription nvarchar(400)
TurkishDescription nvarchar(400)
StartDate datetime
EndDate datetime
Status nvarchar(7)
ProductCategoryKey int PK
ProductCategoryAlternateKey int
EnglishProductCategoryAlternateKey nvarchar(50)
SpanishProductCategoryAlternateKey nvarchar(50)
FrenchProductCategoryAlternateKey nvarchar(50)
ProductSubCategoryKey int PK
ProductCategoryKey int
EnglishProductSubCategoryAlternateKey nvarchar(50)
SpanishProductSubCategoryAlternateKey nvarchar(50)
FrenchProductSubCategoryAlternateKey nvarchar(50)
ProductSubCategoryAlternateKey int
PromotionKey int PK
PromotionAlternateKey int
EnglishPromotionName nvarchar(50)
SpanishPromotionName nvarchar(50)
FrenchPromotionName nvarchar(50)
DiscountPct float
EnglishPromotionType nvarchar(50)
SpanishPromotionType nvarchar(50)
FrenchPromotionType nvarchar(50)
EnglishPromotionCategory nvarchar(50)
SpanishPromotionCategory nvarchar(50)
FrenchPromotionCategory nvarchar(50)
StartDate datetime
EndDate datetime
MinQty int
MaxQty int
ResellerKey int PK
GeographyKey int
ResellerAlternateKey nvarchar(15)
Phone nvarchar(25)
BusinessType nvarchar(20)
ResellerName nvarchar(50)
NumberEmployees int
OrderFrequency char(1)
OrderMonth tinyint
FirstOrderYear int
LastOrderYear int
ProductLine nvarchar(50)
AddressLine1 nvarchar(60)
AddressLine2 nvarchar(60)
AnnualSales money
BankName nvarchar(50)
MinPaymentType tinyint
MinPaymentAmount money
AnnnualRevenue money
YearOpened int
SalesReasonKey int PK
SalesReasonAlternateKey int
SalesReasonType nvarchar(50)
SalesReasonName nvarchar(50)
SalesTerritoryKey int PK
SalesAlternateTerritory int
SalesTerritoryRegion nvarchar(50)
SalesTerritoryCountry nvarchar(50)
SalesTerritoryGroup nvarchar(50)
SalesTerritoryImage varbinary(MAX)
CurrencyKey int PK
DateKey int
AverageRate float
EndofDayRate float
Date datetime
FinanceKey int PK
DateKey int
OrganizationKey int
DepartmentGroupKey int
AccountKey int
Amount float
Date datetime
ProductKey int
OrderDateKey int
DueDateKey int
ShipDateKey int
CustomerKey int
PromotionKey int
CurrencyKey int
SalesTerritoryKey int
SalesOrderNumber nvarchar(20) PK
SalesOrderLineNumber tinyint
RevisionNumber tinyint
OrderQuantity smallint
UntiPrice money
ExtendedAmount money
UntiPriceDiscountPct float
DiscountAmount float
ProductStandardCost money
TotalProductCost money
SalesAmount money
TaxAmt money
Freight money
CarrierTrackingNumber nvarchar(25)
CustomerPONumberOrderDate nvarchar(25)
DueDate datetime
ShipDate datetime
SalesOrderNumber nvarchar(20)
SalesOrderLineNumber tinyint
SalesReasonKey int
ProductKey int PK
DateKey int
MovementDate datetime
UnitCost money
UnitsIn int
UnitsOut int
UnitsBalance int
ProductKey int
OrderDateKey int
DueDateKey int
ShipDateKey int
CustomerKey int
PromotionKey int
CurrencyKey int
SalesTerritoryKey int
SalesOrderNumber nvarchar(20) PK
SalesOrderLineNumber tinyint
RevisionNumber tinyint
OrderQuantity smallint
UntiPrice money
ExtendedAmount money
UntiPriceDiscountPct float
DiscountAmount float
ProductStandardCost money
TotalProductCost money
SalesAmount money
TaxAmt money
Freight money
CarrierTrackingNumber nvarchar(25)
CustomerPONumberOrderDate nvarchar(25)
DueDate datetime
ShipDate datetime
SalesQuotaKey int PK
EmployeeKey int
DateKey int
CalenderYear smallint
CalenderQuarter tinyint
SalesAmountQuota money
Date datetime
Source(Staging)
Column Position Target System Target Schema Target Table
Department
MSS Staging "Staging".Department
MSS Staging "Staging".Department
MSS Staging "Staging".Department
MSS Staging "Staging".Department
Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee
MSS Staging "Staging".Employee

MSS Staging "Staging".Employee

MSS Staging "Staging".Employee
EmployeeDepartmentHistory
MSS Staging "Staging".EmployeeDepa
MSS Staging "Staging".EmployeeDepa
MSS Staging "Staging".EmployeeDepa
MSS Staging "Staging".EmployeeDepa
MSS Staging "Staging".EmployeeDepa
MSS Staging "Staging".EmployeeDepa
EmployeePayHistory
MSS Staging "Staging".EmployeePayH
MSS Staging "Staging".EmployeePayH
MSS Staging "Staging".EmployeePayH
MSS Staging "Staging".EmployeePayH
MSS Staging "Staging".EmployeePayH
JobCandidate
MSS Staging "Staging".JobCandidate
MSS Staging "Staging".JobCandidate
MSS Staging "Staging".JobCandidate
MSS Staging "Staging".JobCandidate
Shift
MSS Staging "Staging".Shift
MSS Staging "Staging".Shift
MSS Staging "Staging".Shift
MSS Staging "Staging".Shift
MSS Staging "Staging".Shift
Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
MSS Staging "Staging".Address
AddressType
MSS Staging "Staging".AddressType
MSS Staging "Staging".AddressType
MSS Staging "Staging".AddressType
MSS Staging "Staging".AddressType
BusinessEntity
MSS Staging "Staging".BusinessEntity
MSS Staging "Staging".BusinessEntity
MSS Staging "Staging".BusinessEntity
BusinessEntityAddress
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
BusinessEntityContact
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
MSS Staging "Staging".BusinessEntit
ContactType
MSS Staging "Staging".ContactType
MSS Staging "Staging".ContactType
MSS Staging "Staging".ContactType
CountryRegion
MSS Staging "Staging".CountryRegion
MSS Staging "Staging".CountryRegion
MSS Staging "Staging".CountryRegion
EmailAddress
MSS Staging "Staging".EmailAddress
MSS Staging "Staging".EmailAddress
MSS Staging "Staging".EmailAddress
MSS Staging "Staging".EmailAddress

MSS Staging "Staging".EmailAddress

Password
MSS Staging "Staging".Password
MSS Staging "Staging".Password
MSS Staging "Staging".Password
MSS Staging "Staging".Password
MSS Staging "Staging".Password
Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
MSS Staging "Staging".Person
PersonPhone
MSS Staging "Staging".PersonPhone
MSS Staging "Staging".PersonPhone
MSS Staging "Staging".PersonPhone
MSS Staging "Staging".PersonPhone
PhoneNumberType
MSS Staging "Staging".PhoneNumber
MSS Staging "Staging".PhoneNumber
MSS Staging "Staging".PhoneNumber
StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
MSS Staging "Staging".StateProvince
BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
MSS Staging "Staging".BillOfMaterials
Culture
MSS Staging "Staging".Culture
MSS Staging "Staging".Culture
MSS Staging "Staging".Culture
Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
MSS Staging "Staging".Document
Illustration
MSS Staging "Staging".Illustration
MSS Staging "Staging".Illustration
MSS Staging "Staging".Illustration
Location
MSS Staging "Staging".Location
MSS Staging "Staging".Location
MSS Staging "Staging".Location
MSS Staging "Staging".Location
MSS Staging "Staging".Location
Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
MSS Staging "Staging".Product
ProductCategory
MSS Staging "Staging".ProductCatego
MSS Staging "Staging".ProductCatego
MSS Staging "Staging".ProductCatego
MSS Staging "Staging".ProductCatego
ProductCostHIstory
MSS Staging "Staging".ProductCostHI
MSS Staging "Staging".ProductCostHI
MSS Staging "Staging".ProductCostHI
MSS Staging "Staging".ProductCostHI
MSS Staging "Staging".ProductCostHI
ProductDescription
MSS Staging "Staging".ProductDescri
MSS Staging "Staging".ProductDescri
MSS Staging "Staging".ProductDescri
MSS Staging "Staging".ProductDescri
ProductDocument
MSS Staging "Staging".ProductDocum
MSS Staging "Staging".ProductDocum
MSS Staging "Staging".ProductDocum
ProductInventory
MSS Staging "Staging".ProductInvent
MSS Staging "Staging".ProductInvent
MSS Staging "Staging".ProductInvent
MSS Staging "Staging".ProductInvent
MSS Staging "Staging".ProductInvent
MSS Staging "Staging".ProductInvent
MSS Staging "Staging".ProductInvent
ProductListHistory
MSS Staging "Staging".ProductListHis
MSS Staging "Staging".ProductListHis
MSS Staging "Staging".ProductListHis
MSS Staging "Staging".ProductListHis
MSS Staging "Staging".ProductListHis
ProductModel
MSS Staging "Staging".ProductModel
MSS Staging "Staging".ProductModel
MSS Staging "Staging".ProductModel
MSS Staging "Staging".ProductModel
MSS Staging "Staging".ProductModel
MSS Staging "Staging".ProductModel
ProductModelIllustration
MSS Staging "Staging".ProductModelIl
MSS Staging "Staging".ProductModelIl
MSS Staging "Staging".ProductModelIl
ProductModelProductDescriptionCulture
MSS Staging "Staging".ProductModelP
MSS Staging "Staging".ProductModelP
MSS Staging "Staging".ProductModelP
MSS Staging "Staging".ProductModelP
ProductPhoto
MSS Staging "Staging".ProductPhoto
MSS Staging "Staging".ProductPhoto
MSS Staging "Staging".ProductPhoto
MSS Staging "Staging".ProductPhoto
MSS Staging "Staging".ProductPhoto
MSS Staging "Staging".ProductPhoto
ProductProductPhoto
MSS Staging "Staging".ProductProduc
MSS Staging "Staging".ProductProduc
MSS Staging "Staging".ProductProduc
MSS Staging "Staging".ProductProduc
ProductReview
MSS Staging "Staging".ProductReview
MSS Staging "Staging".ProductReview
MSS Staging "Staging".ProductReview
MSS Staging "Staging".ProductReview
MSS Staging "Staging".ProductReview
MSS Staging "Staging".ProductReview
MSS Staging "Staging".ProductReview
ProductSubCategory
MSS Staging "Staging".ProductSubCa
MSS Staging "Staging".ProductSubCa
MSS Staging "Staging".ProductSubCa
MSS Staging "Staging".ProductSubCa
MSS Staging "Staging".ProductSubCa
ScrapReason
MSS Staging "Staging".ScrapReason
MSS Staging "Staging".ScrapReason
MSS Staging "Staging".ScrapReason
TransactionHistory
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
MSS Staging "Staging".TransactionHis
TransactionHistoryArchive
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
MSS Staging "Staging".TransactionHi
UnitMeasure
MSS Staging "Staging".UnitMeasure
MSS Staging "Staging".UnitMeasure
MSS Staging "Staging".UnitMeasure
WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
MSS Staging "Staging".WorkOrder
WorkOrderRouting
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
MSS Staging "Staging".WorkOrderRou
ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
MSS Staging "Staging".ProductVendor
PurchaseOrderDetail
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
MSS Staging "Staging".PurchaseOrder
PurchaseOrderHeader
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
MSS Staging "Staging".PurchaseOrde
ShipMethod
MSS Staging "Staging".ShipMethod
MSS Staging "Staging".ShipMethod
MSS Staging "Staging".ShipMethod
MSS Staging "Staging".ShipMethod
MSS Staging "Staging".ShipMethod
MSS Staging "Staging".ShipMethod
Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
MSS Staging "Staging".Vendor
CountryRegionCurrency
MSS Staging "Staging".CountryRegio
MSS Staging "Staging".CountryRegio
MSS Staging "Staging".CountryRegio
CreditCard
MSS Staging "Staging".CreditCard
MSS Staging "Staging".CreditCard
MSS Staging "Staging".CreditCard
MSS Staging "Staging".CreditCard
MSS Staging "Staging".CreditCard
MSS Staging "Staging".CreditCard
Currency
MSS Staging "Staging".Currency
MSS Staging "Staging".Currency
MSS Staging "Staging".Currency
CurrencyRate
MSS Staging "Staging".CurrencyRate
MSS Staging "Staging".CurrencyRate
MSS Staging "Staging".CurrencyRate
MSS Staging "Staging".CurrencyRate
MSS Staging "Staging".CurrencyRate
MSS Staging "Staging".CurrencyRate
MSS Staging "Staging".CurrencyRate
Customer
MSS Staging "Staging".Customer
MSS Staging "Staging".Customer
MSS Staging "Staging".Customer
MSS Staging "Staging".Customer
MSS Staging "Staging".Customer
MSS Staging "Staging".Customer
MSS Staging "Staging".Customer
PersonCreditCard
MSS Staging "Staging".PersonCreditC
MSS Staging "Staging".PersonCreditC
MSS Staging "Staging".PersonCreditC
SalesOrderDetail
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
MSS Staging "Staging".SalesOrderDet
SalesOrderHeader
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
SalesOrderHeaderSalesReason
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
MSS Staging "Staging".SalesOrderHe
SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
MSS Staging "Staging".SalesPerson
SalesPersonQuotaHistory
MSS Staging "Staging".SalesPersonQu
MSS Staging "Staging".SalesPersonQu
MSS Staging "Staging".SalesPersonQu
MSS Staging "Staging".SalesPersonQu
MSS Staging "Staging".SalesPersonQu
SalesReason
MSS Staging "Staging".SalesReason
MSS Staging "Staging".SalesReason
MSS Staging "Staging".SalesReason
MSS Staging "Staging".SalesReason
SalesTaxRate
MSS Staging "Staging".SalesTaxRate
MSS Staging "Staging".SalesTaxRate
MSS Staging "Staging".SalesTaxRate
MSS Staging "Staging".SalesTaxRate
MSS Staging "Staging".SalesTaxRate
MSS Staging "Staging".SalesTaxRate
MSS Staging "Staging".SalesTaxRate
SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
SalesTerritoryHistory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
MSS Staging "Staging".SalesTerritory
ShoppingCartItem
MSS Staging "Staging".ShoppingCart
MSS Staging "Staging".ShoppingCart
MSS Staging "Staging".ShoppingCart
MSS Staging "Staging".ShoppingCart
MSS Staging "Staging".ShoppingCart
MSS Staging "Staging".ShoppingCart
SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
MSS Staging "Staging".SpecialOffer
SpecialOfferProduct
MSS Staging "Staging".SpecialOfferPr
MSS Staging "Staging".SpecialOfferPr
MSS Staging "Staging".SpecialOfferPr
MSS Staging "Staging".SpecialOfferPr
Store
MSS Staging "Staging".Store
MSS Staging "Staging".Store
MSS Staging "Staging".Store
MSS Staging "Staging".Store
MSS Staging "Staging".Store
MSS Staging "Staging".Store
aging)
Target Column Name Target Data Type

DepartmentID smallint
Name nvarchar(50)
GroupName nvarchar(50)
ModifiedDate datetime

BusinessEntityID int
NationalIDNumber nvarchar(15)
LoginID nvarchar(256)
OrganizationNode hierarchyid
OrganizationLevel smallint
JobTitle nvarchar(50)
BirthDate date
MaritalStatus nchar(1)
Gender nchar(1)
HireDate date
SalariedFlag bit
VacationHours smallint
SickLeaveHours smallint

CurrentFlag bit
rowguid uniqueidentifier

BusinessEntityID int
DepartmentID smallint
ShiftID tinyint
StartDate date
EndDate date
ModifiedDate datetime

BusinessEntityID int
RateChangeDate datetime
Rate money
PayFrequency tinyint
ModifiedDate datetime

JobCandidateID int
BusinessEntityID int
Resume xml
ModifiedDate datetime

ShiftID tinyiny
Name nvarchar(50)
StartTime time(7)
EndTime time(7)
ModifiedDate datetime
AddressID int
AddressLine1 nvarchar(60)
AddressLine2 nvarchar(60)
City nvarchar(30)
StateProvinceID int
PostalCode nvarchar(15)
SpatialLocation geography
rowguid uniqueidentifier
ModifiedDate datetime

AddressTypeID int
Name nvarchar(50)
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
AddressID int
AddressIDType int
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
PersonID int
ContactTypeID int
rowguid uniqueidentifier
ModifiedDate datetime

ContactTypeID int
Name nvarchar(50)
ModifiedDate datetime

CountryRegionCode nvarchar(3)
Name nvarchar(50)
ModifiedDate datetime

BusinessEntityID int
EmailAddressID int
EmailAddressID nvarchar(50)
rowguid uniqueidentifier

ModifiedDate datetime

BusinessEntityID int
PasswordHash varchar(128)
PasswordSalt varchar(10)
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
PersonType nchar(2)
NameStyle bit
Title nvarchar(8)
FirstName nvarchar(50)
MiddleName nvarchar(50)
LastName nvarchar(50)
Suffix nvarchar(10)
EmailPromotion int
AdditionalContactInfo xml
Demographics xml
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
PhoneNumber nvarchar(25)
PhoneNumberTypeID int
ModifiedDate datetime

PhoneNumberTypeID int
Name nvarchar(50)
ModifiedDate datetime

StateProvinceID int
StateProvinceCode nvchar(3)
CountryRegionCode nvarchar(3)
IsOnlyStateProvinceFlabit
Name nvarchar(50)
TerritotyID int
rowguid uniqueidentifier
ModifiedDate datetime

BillOfMaterialsID int
ProductAssemblyID int
ComponentID int
StartDate datetime
EndDate datetime
UnitMeasureCode nchar(3)
BOMLevel smallint
PerAssemblyQty decimal(8,2)
ModifiedDate datetime

CultureID nchar(6)
Name nvarchar(50)
ModifiedDate datetime

DocumentNode hierarchyid
DocumentLevel smallint
Title nvarchar(50)
Owner int
FolderFlag bit
FileName nvarchar(400)
FileExtension nvarchar(8)
Revision nchar(5)
ChangeNumber int
Status tinyint
DocumentSummary nvarchar(MAX)
Document varbinary(MAX)
rowguid uniqueidentifier
ModifiedDate datetime

IllustrationID int
Diagram xml
ModifiedDate datetime

LocationID smallint
Name nvarchar(50)
CostRate smallmoney
Availability decimal(8,2)
ModifiedDate datetime

ProductID int
Name nvarchar(50)
MakeFlag bit
FinishedGoodFlag bit
Color nvarchar(15)
SafetyLockLevel smallint
ReorderPoint smallint
StandardCost money
ListPrice money
Size nvarchar(5)
SizeUnitMeasureCode nchar(3)
WeightUnitMeasureCodnchar(3)
Weight decimal(8,2)
DaysToMnufacture int
ProductLine nchar(2)
Class nchar(2)
Style nchar(2)
ProductSubCategoryID int
SellStartDate datetime
SellEndDate datetime
DiscontinuedDate datetime
rowguid uniqueidentifier
ModifiedDate datetime

ProductCategoryID int
Name nvarchar(50)
rowguid uniqueidentifier
ModifiedDate datetime

ProductID int
StartDate datetime
EndDate datetime
StandardCost money
ModifiedDate datetime

ProductDescriptionID int
Description nvarchar(400)
rowguid uniqueidentifier
ModifiedDate datetime

ProductID int
DocumentNode hierarchyid
ModifiedDate datetime

ProductID int
LocationID smallint
Shelf nvarchar(10)
Bin tinyint
Quantity smallint
rowguid uniqueidentifier
ModifiedDate datetime

ProductID int
StartDate datetime
EndDate datetime
ListPrice money
ModifiedDate datetime

ProductModelID int
Name nvarchar(50)
CatalogDescription xml
Instructions xml
rowguid uniqueidentifier
ModifiedDate datetime

ProductModelID int
IllustrationID int
ModifiedDate datetime
ProductModelID int
ProductDescriptionID int
CultureID nchar(6)
ModifiedDate datetime

ProductPhotoID int
ThumbNailPhoto varbinary(MAX)
ThumbNailPhotoFileNa nvarchar(50)
LargePhoto varbinary(MAX)
LargePhotoFileName nvarchar(50)
ModifiedDate datetime

ProductID int
ProductPhotoID int
Primary bit
ModifiedDate datetime

ProductReviewID int
ProductID int
ReviewerName nvarchar(50)
EmailAddress nvarchar(50)
Rating int
Comments nvarchar(3850)
ModifiedDate datetime

ProductSubCategoryID int
ProductCategoryID int
Name nvarchar(50)
rowguid uniqueidentifier
ModifiedDate datetime

ScrapReasonID smallint
Name nvarchar(50)
ModifiedDate datetime

TransactionID int
ProductID int
ReferenceOrderID int
ReferenceOrderLineID int
TransactionDate datetime
TransactionType nchar(1)
Quantity int
ActualCost money
ModifiedDate datetime

UnitMeasureCode nchar(3)
Name nvarchar(50)
ModifiedDate datetime

WorkOrderID int
ProductID int
OrderQty int
ScrappedQty smallint
StartDate datetime
EndDate datetime
DueDate datetime
ScrapReasonID smallint
ModifiedDate datetime

WorkOrderID int
ProductID int
OperationSequence smallint
LocationID smallint
ScheduledStartDate datetime
ScheduledEndDate datetime
ActualStartDate datetime
ActualEndDate datetime
ActualResourceHrs decimal(9,4)
PlannedCost money
ActualCost money
ModifiedDate datetime

ProductID int
BusinessEntityID int
AverageLeadTime int
StandardPrice money
LastReceiptCost money
LastReceiptDate datetime
MinOrderQty int
MaxOrderQty int
OnOrderQty int
UnitMeasureCode nchar(3)
ModifiedDate datetime

PurchaseOrderID int
PurchaseOrderDetailIDint
DueDate datetime
OrderQty int
ProductID int
UnitPrice money
LineTotal money
ReceivedQty decimal(8,2)
RejectedQty decimal(8,2)
StockedQty decimal(9,2)
ModifiedDate datetime

PurchaseOrderID int
RevisionNumber tinyint
Status tinyint
EmployeeID int
VendorID int
ShipMethodID int
OrderDate datetime
ShipDate datetime
SubTotal money
TaxAmt money
Freight money
TotalDue money
ModifiedDate datetime

ShipMethodID int
Name nvarchar(50)
ShipBase money
ShipRate money
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
AccountNumber nvarchar(15)
Name nvarchar(50)
CreditRating tinyint
PreferredVendorStatusbit
ActiveFlag bit
PurchasingWebServicenvarchar(1024)
ModifiedDate datetime

CountryRegionCode nvarchar(3)
CurrencyCode nchar(3)
ModifiedDate datetime

CreditCardID int
CardType nvarchar(50)
CardNumber nvarchar(25)
ExpMonth tinyint
ExpYear smallint
ModifiedDate datetime

CurrencyCode nchar(3)
Name nvarchar(50)
ModifiedDate datetime

CurrencyRateID int
CurrencyRateDate datetime
FromCurrencyCode nchar(3)
ToCurrencyCode nchar(3)
AverageRate money
EndOfDayRate money
ModifiedDate datetime

CustomerID int
PersonID int
StoreID int
TerritotyID int
AccountNumber varchar(10)
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
CreditCard int
ModifiedDate datetime

SalesOrderID int
SalesOrderDetail int
CarrierTrackingNumbernvarchar(25)
OrderQty smallint
ProductID int
SpecialOfferID int
UnitPrice money
UnitPriceDiscount money
LineTotal numeric
rowguid uniqueidentifier
ModifiedDate datetime

SalesOrderID int
RevisionNumber tinyint
OrderDate datetime
DueDate datetime
ShipDate datetime
Status tinyint
OnlineOrderFlag bit
SalesOrderNumber nvarchar(23)
PurchaseOrderNumbernvarchar(25)
AccountNumber nvarchar(15)
CustomerID int
SalesPersonID int
TerritotyID int
BillToAddressID int
ShipToAddressID int
ShipMethodID int
CreditCardID int
CreditCardApprovalCo varchar(15)
CurrencyRateID int
SubTotal money
TaxAmt money
Freight money
TotalDue money
Comment nvarchar(128)
rowguid uniqueidentifier
ModifiedDate datetime

SalesOrderID int
SalesReasonID int
ModifiedDate datetime

BusinessEntityID int
TerritoryID int
SalesQuota money
Bonus money
CommissionPct smallmoney
SalesYTD money
SalesLastYear money
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
QuotaDate datetime
SalesQuota money
rowguid uniqueidentifier
ModifiedDate datetime

SalesReasonID int
Name nvarchar(50)
ReasonType nvarchar(50)
ModifiedDate datetime

SalesTaxRateID int
StateProvinceID int
TaxType tinyint
TaxRate smallmoney
Name nvarchar(50)
rowguid uniqueidentifier
ModifiedDate datetime

TerritotyID int
Name nvarchar(50)
CounrtyRegionCode nvarchar(3)
Group nvarchar(50)
SalesYTD money
SalesLastYear money
CostYTD money
CostLastYear money
rowguid uniqueidentifier
ModifiedDate datetime

BusinessEntityID int
TerritotyID int
StartDate datetime
EndDate datetime
rowguid uniqueidentifier
ModifiedDate datetime

ShoppingCartItemID int
ShoppingCartID int
Quantity int
ProductID int
DateCreated datetime
ModifiedDate datetime

SpecialOfferID int
Description nvarchar(255)
DiscountPct smallmoney
Type nvarchar(50)
Category nvarchar(50)
StartDate datetime
EndDate datetime
MinQty int
MaxQty int
rowguid uniqueidentifier
ModifiedDate datetime

SpecialOfferProductID int
ProductID int
rowguid uniqueidentifier
ModifiedDate datetime

StoreBusinessEntityID int
Name nvarchar(50)
SalesPersonID int
Demographics xml
rowguid uniqueidentifier
ModifiedDate datetime

04a - PPT4 - Business Requirements - R0
No ratings yet
04a - PPT4 - Business Requirements - R0
20 pages
Unit 2 Global E Business and Collaboration 1
No ratings yet
Unit 2 Global E Business and Collaboration 1
16 pages
Ch3 - AisProf1 - Narrative Report
No ratings yet
Ch3 - AisProf1 - Narrative Report
15 pages
Dimensional Modeling for Business
No ratings yet
Dimensional Modeling for Business
14 pages
Statistical Sales Conditions (34B - MX) : Test Script SAP S/4HANA - 30-08-19
No ratings yet
Statistical Sales Conditions (34B - MX) : Test Script SAP S/4HANA - 30-08-19
19 pages
Data Warehouse Modeling Guide
No ratings yet
Data Warehouse Modeling Guide
9 pages
Smart Industries
No ratings yet
Smart Industries
17 pages
Corporate Organization Insights
88% (8)
Corporate Organization Insights
25 pages
2011 - Zachman Framework For Enterprise Architecture 3.0
No ratings yet
2011 - Zachman Framework For Enterprise Architecture 3.0
1 page
Business Intelligence Essentials
No ratings yet
Business Intelligence Essentials
30 pages
Dimensional Modeling Fundamentals Guide
100% (1)
Dimensional Modeling Fundamentals Guide
19 pages
Data Warehouse Toolkit Classics - Kimball Ross Muncy Becker
No ratings yet
Data Warehouse Toolkit Classics - Kimball Ross Muncy Becker
56 pages
ML03 Process Selection
No ratings yet
ML03 Process Selection
23 pages
R12.1 Movement Statistics Process Flow Diagram
100% (1)
R12.1 Movement Statistics Process Flow Diagram
3 pages
Dimensional Modeling
No ratings yet
Dimensional Modeling
40 pages
Data Warehouse Design & Analysis
No ratings yet
Data Warehouse Design & Analysis
12 pages
5 Lecture 5-Building Dimensional Models
No ratings yet
5 Lecture 5-Building Dimensional Models
32 pages
C1 Introduction
No ratings yet
C1 Introduction
48 pages
Data Warehousing Lab Guide
100% (1)
Data Warehousing Lab Guide
13 pages
Data Insights for Manufacturing Execs
No ratings yet
Data Insights for Manufacturing Execs
3 pages
Dimensional Modeling
No ratings yet
Dimensional Modeling
182 pages
Chapter I
No ratings yet
Chapter I
21 pages
QWT BusinessIntelligencePlan
No ratings yet
QWT BusinessIntelligencePlan
20 pages
Configuring SAP: Enterprise Wide Information Systems
No ratings yet
Configuring SAP: Enterprise Wide Information Systems
43 pages
Configuring SAP: Enterprise Wide Information Systems
No ratings yet
Configuring SAP: Enterprise Wide Information Systems
43 pages
Uttam Galva Sales Org Structure Document
No ratings yet
Uttam Galva Sales Org Structure Document
8 pages
Batch Characteristic SAP
No ratings yet
Batch Characteristic SAP
5 pages
SAD Lec 2 Business Processes
No ratings yet
SAD Lec 2 Business Processes
64 pages
34B S4hana1909 BPD en Us
No ratings yet
34B S4hana1909 BPD en Us
21 pages
1 AS-IS - SD-C01 - SD Org Structure R2 - Domestic
No ratings yet
1 AS-IS - SD-C01 - SD Org Structure R2 - Domestic
7 pages
3 - AS-IS - SD-C02 - Customer Master R2 - Domestic
No ratings yet
3 - AS-IS - SD-C02 - Customer Master R2 - Domestic
8 pages
QWT BusinessIntelligencePlan PDF
No ratings yet
QWT BusinessIntelligencePlan PDF
20 pages
Lab1 Dimensional Modeling
100% (3)
Lab1 Dimensional Modeling
14 pages
Chapter 4: The Fulfillment Process: Magal and Word - Essentials of Business Processes and Information Systems - © 2009
No ratings yet
Chapter 4: The Fulfillment Process: Magal and Word - Essentials of Business Processes and Information Systems - © 2009
35 pages
Business Processes and Information Syste PDF
No ratings yet
Business Processes and Information Syste PDF
5 pages
Business Processes & IT Systems
No ratings yet
Business Processes & IT Systems
5 pages
Process Design2
No ratings yet
Process Design2
45 pages
DR Akarte NITIE Perspectives in Manufacturing Management
No ratings yet
DR Akarte NITIE Perspectives in Manufacturing Management
18 pages
Introduction to Business Process Management
No ratings yet
Introduction to Business Process Management
47 pages
BI in Retail Industry: Presented By: Vivek Sharma (09BM8062) Ashutosh Sinha (09BM8067), Mba 2 Year VGSOM, IIT Kharagpur
No ratings yet
BI in Retail Industry: Presented By: Vivek Sharma (09BM8062) Ashutosh Sinha (09BM8067), Mba 2 Year VGSOM, IIT Kharagpur
19 pages
LAB 1: Discrete Mes: Serialized Manufacturing and Genealogy: 1. Log Into Portal Field Value
No ratings yet
LAB 1: Discrete Mes: Serialized Manufacturing and Genealogy: 1. Log Into Portal Field Value
40 pages
Lab1 Dimensional Modeling
No ratings yet
Lab1 Dimensional Modeling
13 pages
0034M - Informasi & Proses Bisnis: Week 1 Introduction & Business Process
No ratings yet
0034M - Informasi & Proses Bisnis: Week 1 Introduction & Business Process
40 pages
Inventory: Kimball & Ross, Chapter 3
No ratings yet
Inventory: Kimball & Ross, Chapter 3
20 pages
D365FO - Training Slide - Master Planning - Ver1.0
No ratings yet
D365FO - Training Slide - Master Planning - Ver1.0
20 pages
The Product Process Matrix
0% (1)
The Product Process Matrix
7 pages
ISP531 Chapter 1
No ratings yet
ISP531 Chapter 1
48 pages
Process & Capacity Analysis
No ratings yet
Process & Capacity Analysis
99 pages
QWT BusinessIntelligencePlan
No ratings yet
QWT BusinessIntelligencePlan
20 pages
QWT BusinessIntelligencePlan
No ratings yet
QWT BusinessIntelligencePlan
20 pages
Batch Management
No ratings yet
Batch Management
166 pages
Basics 1 Implementation User Creation
No ratings yet
Basics 1 Implementation User Creation
123 pages
Chapter 2 - MIS
No ratings yet
Chapter 2 - MIS
50 pages
1st Unit KTU OMgmt
No ratings yet
1st Unit KTU OMgmt
67 pages
LOutline 3 F 15
No ratings yet
LOutline 3 F 15
87 pages
BPM 01 Introduction-Eng
No ratings yet
BPM 01 Introduction-Eng
21 pages
RDBMS Practical 5
No ratings yet
RDBMS Practical 5
2 pages
DBMS Previous Questions Module Wise
No ratings yet
DBMS Previous Questions Module Wise
7 pages
Understanding Database Anomalies
No ratings yet
Understanding Database Anomalies
22 pages
Sow Ict200
No ratings yet
Sow Ict200
5 pages
Rdbms
No ratings yet
Rdbms
88 pages
Database Management Systems Overview
No ratings yet
Database Management Systems Overview
17 pages
Dbms Unit 1
No ratings yet
Dbms Unit 1
65 pages
UML Class Diagram for Course System
No ratings yet
UML Class Diagram for Course System
1 page
Political Science: An Academic Insight
0% (1)
Political Science: An Academic Insight
33 pages
DBMS PBL
No ratings yet
DBMS PBL
36 pages
Example of SDS
No ratings yet
Example of SDS
7 pages
Worksheet Database Cambridge With Answer
No ratings yet
Worksheet Database Cambridge With Answer
2 pages
07 07 2025 SR Star Test 2 MS
No ratings yet
07 07 2025 SR Star Test 2 MS
6 pages
DBMS MCQ Resources and Questions
100% (1)
DBMS MCQ Resources and Questions
29 pages
AMD Exercise 01 Overview and Details
No ratings yet
AMD Exercise 01 Overview and Details
22 pages
Power BI Data Modeling Essentials
No ratings yet
Power BI Data Modeling Essentials
13 pages
Understanding Database Types and SQL
No ratings yet
Understanding Database Types and SQL
97 pages
Database Management - BIT 2
No ratings yet
Database Management - BIT 2
266 pages
Fundamentals of Database Systems Module
No ratings yet
Fundamentals of Database Systems Module
43 pages
Reynaers - CW 50 - Guidelines For Revit
No ratings yet
Reynaers - CW 50 - Guidelines For Revit
4 pages
Database Management System Guide
No ratings yet
Database Management System Guide
303 pages
Untitled Document
No ratings yet
Untitled Document
7 pages
105 Unit 4
No ratings yet
105 Unit 4
17 pages
Models vs. Examples in the Anthropocene
No ratings yet
Models vs. Examples in the Anthropocene
13 pages
09-Views and Constraints
No ratings yet
09-Views and Constraints
19 pages
Modeling and Simulation of Turret Stabilization Wi
No ratings yet
Modeling and Simulation of Turret Stabilization Wi
6 pages
Grade 10 - Base Question-Answer
No ratings yet
Grade 10 - Base Question-Answer
2 pages
Info125 Notes1
No ratings yet
Info125 Notes1
54 pages
Guide To SQL 9th Edition by Pratt Last Solution Manual
100% (67)
Guide To SQL 9th Edition by Pratt Last Solution Manual
22 pages
Company Database ER Diagram & Schema
No ratings yet
Company Database ER Diagram & Schema
74 pages

Adventure Works Work Book

Uploaded by

Adventure Works Work Book

Uploaded by

Fact Type of

Business Process Fact Tables

Sales Overview FactFinance Transaction

smallint PK MSS HumanResources

int PK MSS HumanResources

int PK MSS HumanResources

int PK MSS HumanResources

int PK MSS HumanResources

tinyiny PK MSS HumanResources

int PK MSS Person

int PK MSS Person

int PK MSS Person

int PK MSS Person

int PK MSS Person

nvarchar(3) PK MSS Person

int PK MSS Person

int PK MSS Person

int PK MSS Person

int PK MSS Person

int PK MSS Person

int MSS Person

int MSS Production

nchar(6) MSS Production

int PK MSS Production

smallint PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Production

smallint PK MSS Production

int PK MSS Production

int PK MSS Production

nchar(3) PK MSS Production

int PK MSS Production

int PK MSS Production

int PK MSS Purchasing

int PK MSS Purchasing

int PK MSS Purchasing

int PK MSS Purchasing

int PK MSS Purchasing

nvarchar(3) PK MSS Sales

int PK MSS Sales

nchar(3) PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

int PK MSS Sales

MSS dbo DimAccount

MSS Staging "Staging".Employee

MSS Staging "Staging".EmailAddress

You might also like