Amol Pandey

Experiments, tutorials and ideas on developing business intelligence solutions

Skip to content
Menu
  • Home
  • About Me

Tag: Query

DataWarehouse – Generate Date Dimension Optimally
SQL

DataWarehouse – Generate Date Dimension Optimally

Posted on August 16, 2016August 16, 2016 by Amol Pandey

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…

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

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

Posted on August 6, 2016 by Amol Pandey

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…

Hot Topics

Backup C# Catalog CD CI Code command config CSharp Cube Data Deploy Deployment Docker Gulp Jenkins Job Key long Management Master MSSQL MVC NET pandas pem Processing Python Query Report running Script Service Setup SQL SSAS SSIS SSISDB ssl SSRS TFS ubuntu UDF VSTS Web

Categories

Archives

© Copyright 2023 – Amol Pandey
Wisteria Theme by WPFriendship ⋅ Powered by WordPress