Experiments, tutorials and ideas on developing business intelligence solutions
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 …
Hi, Recently I got engaged in a discussion, Which I feel the ones that really was an eye opener for me and some thing i thought trivial played an important role in my day today work. The conversation went as What is the effect of WHERE clause in a (INNER/LEFT/RIGHT) join, if moved to ON clause Read More …