Last day on LinkedIn, I saw a post in my feed about a woman who was making her transistion into the BI field. In this particular post she posted her solution to a LeetCode problem, the original problem is this one here: https://leetcode.com/problems/second-highest-salary/description/ As you saw, the problem consisted of retrieving the second highest salary […]
Each problem has different approaches Read More »
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 »
One of the most important aspects in data warehousing and Business Intelligence, is the ability to look back in time. In fact tables this is not necessary due to the fact being registered on a set time. Dimensions do not record the moment some of their attributes change.In this blog I want to show you
Tracking history in dimensions Read More »