Data Warehouse · ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 6. ETL – Documentation

Understanding Transformations: Setup and Renaming Columns for Legibility........READ MORE......

Advertisements
Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(d) – Working with NULLS

NULL is used to indicate an unknown or missing value. NULL is not equivalent to zero or an empty string. Arithmetic or string. CLICK to READ ....

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(c) – Data Types

Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numeric, approximate numeric, character, date/time, binary, and other. CLICK TO READ...................

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(b) – SELECT statement

Use the SELECT statement to retrieve a rowset of data from tables and views in a database.. CLICK TO READ --------------

Microsoft Data Technology · Microsoft SSDB · Transact SQL

TSQL – Part 1(a) – Introduction to Transact SQL

Transact-SQL is an essential skill for database professionals and developers working with Microsoft SQL Server. CLICK to READ -----------------

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 5. ETL – Delete VS Truncate

SSDB ETL - Delete vs Truncate

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 3. ETL – Slowly Changing Dimension SCD Type 1

Tracking Changes Over Time Setup and SCD Type 1.

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 2. ETL – Incremental Loading process with Merge Statement

Incremental Loading with Merge.

Data Warehouse · ETL using SSDB · Microsoft Data Technology · Microsoft SSDB · Microsoft SSIS

SSDB – Part 4. ETL – Slowly Changing Dimension SCD Type 2 and 3

Extract Transform and Load using SQL server database stored procedure.

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 1. ETL – Flush and Fill Versus Incremental Loading

Flush and Fill Verses Incremental Loading A great place to begin when designing an ETL process is to decide if you will use an incremental load versus the simpler flush and fill technique. With incremental loading, you insert, update, or delete data in destination tables that have changed in the source table on a row by… Continue reading SSDB – Part 1. ETL – Flush and Fill Versus Incremental Loading