DataWarehouse – Generate Date Dimension Optimally
Hi Recently I was working on a data warehouse project and was tasked to generate a date dimension table. Now some of the available options for me to achieve the same are listed out as below: Using the loops in SQL to iterate and populate dates Using the date wizard in SSAS (multidimensional) Copy the Read More …