ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 13. ETL – Connecting Foreign Keys to Surrogate Keys

Connecting Foreign Keys to Surrogate Keys

Advertisements
ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 12. ETL – Creating Date Lookup Tables

Creating Date Lookup Tables

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 11. ETL – Redefining Nullable Values for Enhanced Reporting

Redefining Nullable Values for Enhanced Reporting: CLICK to Continue Reading.......

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 10. ETL – Combining Data from Multiple Tables

Combining data from multiple tables: CLICK to continue reading....

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 9. ETL – Reformatting Data to Make it More Readable

Reformatting Data to Make it More Readable.....CLICK to Continue reading..........

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 8. ETL – Converting Data types for consistency

Converting Data Types for consistency:......... READ/VIEW VIDEO.................

Microsoft Data Technology · Microsoft SSDB · Transact SQL

SSDB – Part 7. ETL – Splitting and Merging Columns

There are specific transformations that you will likely use more than others, and learning how to program these will make creating any ETL process easier......... READ/VIEW VIDEO.................

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......

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...................