joel.fail

The stories of my failures
Menu

Microsoft Azure

Work-around for Id columns in Dimensions using Synapse Serverless SQL engine

Leave a Comment / Data Engineering, Microsoft Azure, Microsoft SQL Server /

Azure Synapse is one of the latest flagship tools for analytics within the Azure Cloud. Synapse analytics is an all-in-one platform for data integration, processing, data warehousing and analytics. Azure Synapse is very cost efficient and highly advised for small to middle companies to start their BI landscape. However Synapse has some peculiarities, one of […]

Work-around for Id columns in Dimensions using Synapse Serverless SQL engine Read More »

Using mini dimension for fast-changing attributes

Leave a Comment / Data Engineering, General, Microsoft Azure, Microsoft SQL Server /

Introduction This blog post will be about the use of mini-dimensions for fast-changing attributes, also known as the type 4 slowly changing dimension. Dimension tables in a dimensional model are usually wide and contain alot of attributes. If the case is there where one or a few of the attributes are fast changing, then this

Using mini dimension for fast-changing attributes Read More »