/* Vendor Usage — fact sample / load check (DatawarehouseNCM) Fact: dbo.FactVendorUsage */ -- Detail sample SELECT TOP 100 f.UsageReportType, f.CorpCode, f.TEFileNo, f.TELastName, f.OrderDate, f.VendorParentID, f.CompanyName, f.CompanySubName, f.VendorID, f.ServiceCode, f.ServiceType, f.SrvcProvider, f.HHGAutoShipment, f.DimMainID FROM dbo.FactVendorUsage f ORDER BY f.UsageReportType, f.OrderDate DESC, f.CorpCode; -- Totals by report type SELECT f.UsageReportType, COUNT(*) AS [RowCount], MIN(f.OrderDate) AS MinOrderDate, MAX(f.OrderDate) AS MaxOrderDate FROM dbo.FactVendorUsage f GROUP BY f.UsageReportType ORDER BY f.UsageReportType; -- DimMain FK coverage SELECT COUNT(*) AS TotalRows, SUM(CASE WHEN f.DimMainID IS NULL THEN 1 ELSE 0 END) AS NullDimMain FROM dbo.FactVendorUsage f;