Kategorie: Pattern
-
SCD2 simplified example
When dealing with Slowly Changing Dimension Type 2 (SCD2) in a data warehouse, a common practice is to use a staging pattern to handle the loading and processing of data before it is inserted into the final dimension table. This staging pattern helps manage historical…
-
Create #TempTable with T-SQL
Microsoft SQL Server (T-SQL) offers a convenient way with the ‚INTO‘ statement to create a temporary table and populate it with the results of a query in a single statement.
-
Accurate percentages with row-level security
Pattern to compute ratios, when data is hidden by row-level security.
-
-
Current Period: avoid reporting issues
Abstract, from a SQLBI article. Link to the original article on SQLBI.com click here https://sql.bi/817168. I just could recommend to read every single article from SQLBI, Alberto Ferrari XOR Marco Russo in full length. Below some key pattern and notes from my side as my…
-
CallBackID issues: Cardinality
Abstract, from a SQLBI article. Link to the original article on SQLBI.com click herehttps://sql.bi/816722. I just could recommend to read every single article from SQLBI, Alberto Ferrari XOR Marco Russo in full length. Below some key pattern and notes from my side as my personal…
