Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.
I will be doing incremental dimension loading amoung 3 databases. All 3 of them are on the same server. I have a transactional DB Salome...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
- Apr 16, 2022
- 7 min
Change Data Capture (CDC) In SQL Server
Incremental load for inserts (no updates or deletes) Incremental load for insert, update, delete Overview SQL Server Change Data Capture...
3200
Marek Vavrovic
- Apr 6, 2022
- 1 min
Using T-SQL to create a bank loan statement
CREATE PROC sp_LoanAmount ( --Supplying default values @LoanAmount Money = 1000, @RateOfInterest decimal(5,2) = 5, @TimePeriod tinyint =...
1150
Marek Vavrovic
- Apr 5, 2022
- 3 min
Update table using join statement
Examples of SQL Update Join RIGHT JOIN LEFT JOIN INNER JOIN WHERE clause CASE statement Computed Columns create table MyTarget (id int...
300
Marek Vavrovic
- Apr 4, 2022
- 5 min
SQL Server Transactions
What is a Transaction in SQL Server? A transaction is a set of SQL statements that should be executed as one unit. That means a...
530
Marek Vavrovic
- Mar 31, 2022
- 3 min
HuffnerTextile - Data Visualisation PowerBI Desktop
Data Models Data are loaded from the data warehouse database. Using Import Mode. Can't use DirectQuery Mode for Live Connection because I...
270
Marek Vavrovic
- Mar 30, 2022
- 10 min
HuffnerTextile - Multidimensional Model
Links to download: MDX - CALCULATIONS Gross Profit Gross Profit Margin Gross Profit Y-o-Y % Growth Cost Ratio Error Ratio Error Meters...
210
Marek Vavrovic
- Mar 30, 2022
- 2 min
HuffnerTextile - Tabular Model
HufferTextileDW.abf HuffnerTextile.sln This solution contains 4 Perspectives. The way you create them is when you click on the New...
190
Marek Vavrovic
- Mar 30, 2022
- 4 min
HuffnerTextile - SSIS Initial data load.
Examples of BI joins -Dimensions DimEmployee Select [EmployeeID] [EmployeeKey], case when [EmployeeID] = 2 then 1 when [EmployeeID] in...
320
Marek Vavrovic
- Mar 30, 2022
- 3 min
Huffner Textile - Data Warehouse Design
Files to download: -sql database backup -SQL Server Database Project Types of Data Warehouse Schema STAR SCHEMA The simplest and the most...
220
Marek Vavrovic
- Mar 30, 2022
- 3 min
Huffner Textile - Relational database
Database Design Objective Eliminate Data Redundancy: the same piece of data shall not be stored in more than one place. This is because...
340