DataWarehouse – Generate Date Dimension Optimally

Posted onAugust 16, 2016August 16, 20162 Comments

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 …

SQL: Joins and Where clause, a mix to be aware (Logical Query Processing Phases)

Posted onAugust 6, 2016Leave a comment

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 …

Amol Pandey

Experiments, tutorials and ideas on developing business intelligence solutions

Tag: Query

DataWarehouse – Generate Date Dimension Optimally

SQL: Joins and Where clause, a mix to be aware (Logical Query Processing Phases)