再正規化は、Endeca Server内の非正規化データ・モデルにおいても、また複数値属性を分析するときにも重要です。
Quick Startのデータでは、次の例に示すように、Employeesは非正規化状態でTransactions上に存在していました。
DimEmployee_FullName: | Tsvi Michael Reiter |
DimEmployee_HireDate: | 2005-07-01T04:00:00.000Z |
DimEmployee_Title: | Sales Representative |
FactSales_RecordSpec: | SO49122-2 |
FactSales_SalesAmount: | 939.588 |
RETURN AvgTenure AS SELECT AVG(CURRENT_DATE - DimEmployee_HireDate) AS AvgTenure GROUP BY DimEmployee_Title
DEFINE Employees AS SELECT DimEmployee_HireDate AS DimEmployee_HireDate, DimEmployee_Title AS DimEmployee_Title GROUP BY DimEmployee_EmployeeKey; RETURN AvgTenure AS SELECT AVG(CURRENT_DATE - DimEmployee_HireDate) AS AvgTenure FROM Employees GROUP BY DimEmployee_Title