Showing posts with label Data Warehousing. Show all posts
Showing posts with label Data Warehousing. Show all posts
Saturday, April 2, 2022

Azure Synapse Analytics - Part III - Serverless SQL Pool

›
Azure Synapse Serverless SQL Pool facilitates data exploration, transformations and data warehousing with multiple functionalities, allowing...
Tuesday, April 2, 2019

Azure Databricks - What, Why & How - YouTube Video

›
Here is the first video on Azure Databricks. This talks about; Why we need to Azure Databricks for processing data What is Azure Databr...
Thursday, January 4, 2018

Introduction to Azure Data Lake Store - Does it replace the Data Warehouse?

›
I have made a video on Azure Data Lake and Azure Data Lake Store and published in YouTube. This video explains What is Azure Data Lake, It...
Monday, September 11, 2017

SQL Server - Merging Partitions - Does it physically move data from a data file to another?

›
Partitioning is a common practice when maintaining large number of records in tables regardless of the database type: whether the database...
Thursday, September 7, 2017

Dimension with just one attribute - data warehouse design

›
Have you ever come across a situation where you have to design a dimension that has no attributes except the one explain the dimension its...
Monday, August 14, 2017

Azure SQL Data Warehouse - Part II - Analyzing Created Databases

›
I started writing on this long time back but had no way of completing it. My first post on this was  Azure SQL Data Warehouse - Part I - C...
Friday, August 4, 2017

bcp error - Invalid column type from bcp client for colid 1 - Solution

›
You might be experiencing the following error with bcp when loading text data to SQL Server table; It is possible to see this erro...
Thursday, August 3, 2017

Script for creating DimTime Dimension Table and populating data

›
The posts I made on date dimension table ( Script for populating Date Dimension with Financial Year and  Loading Data Script for Snowflak...
Tuesday, August 1, 2017

Script for populating Date Dimension with Financial Year

›
Once I published the code I used for creating date dimension tables and populating data. But it had not handled finance year related date ...
Saturday, March 25, 2017

Loading Data Script for Snowflake type Date Dimension

›
Update: If you need the script for the same with financial year elements, read the new post . Date dimension is the most common dimensio...
Tuesday, December 6, 2016

Azure SQL Data Warehouse - Part I - Creating and Connecting

›
We have been implementing on-premises data warehouses for years and everyone is well aware on difficulties-faced at the first phase of the...
3 comments:
Monday, October 24, 2016

Disable PRIMARY KEY before data loading

›
In order to improve the loading performance, specifically when a data warehouse or a large table is loaded, it is recommended to disable c...
Friday, July 29, 2016

Fact Loading: Switching a loaded temporary table into an empty partition of the fact table

›
Fact table in data warehouses are always partitioned and with most of solutions, it is partitioned on a date key. Generally, we use SSIS f...
Thursday, July 28, 2016

SSIS - Fact Loading with Dimension Type II and Dimension Type I

›
The Dimensional Modeling in data warehousing, either using Star or Snowflake schema is still the most famous structure applied and widely ...
Friday, July 8, 2016

Conformed dimensions and Stovepipe data marts

›
Long time back, I wrote a small note on Stovepipe data marts, thought make a blog post again on it as it is still unknown to many. The sim...