/* GMS Active Assignee - fact sample / load check (DatawarehouseNCM) Fact: dbo.FactGMSActiveAssignee Quick check that FactGMSActiveAssignee loaded and the dimension FKs resolved. */ -- Detail sample SELECT TOP 100 f.CorpCode, f.TEFileNo, f.TEAssignmentID, f.TEName, f.DivisionName, f.ReloPolicy, f.AssignmentType, f.HomeCountry, f.HostCountry, f.AssignEstStartDate, f.AssignEstEndDate, f.Status, f.DimMainID, f.DimDivisionID, f.DimPolicyID FROM dbo.FactGMSActiveAssignee f ORDER BY f.CorpCode, f.TEFileNo, f.TEAssignmentID; -- Totals by status SELECT f.Status, COUNT(*) AS [RowCount] FROM dbo.FactGMSActiveAssignee f GROUP BY f.Status ORDER BY f.Status; -- Dimension FK coverage (unresolved keys should be investigated) SELECT COUNT(*) AS TotalRows, SUM(CASE WHEN f.DimMainID IS NULL THEN 1 ELSE 0 END) AS NullDimMain, SUM(CASE WHEN f.DimDivisionID IS NULL THEN 1 ELSE 0 END) AS NullDimDivision, SUM(CASE WHEN f.DimPolicyID IS NULL THEN 1 ELSE 0 END) AS NullDimPolicy FROM dbo.FactGMSActiveAssignee f;