Tags » SQL Query

SSDB - Part 14. ETL - Implementing ETL with SQL Objects (VIEWS)

Working with ETL Objects

It has long been a best practice to build software using multiple layers of abstraction. By creating an abstraction layer, the underlying objects are always used indirectly. 220 more words

Microsoft Data Technology

SSDB - Part 12. ETL - Creating Date Lookup Tables

Creating Data Lookup Tables: CLICK to continue reading……..

Note: Microsoft is the owner of the content and video in this blog post.

Microsoft Data Technology

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

Handling Nulls

Null values represent a challenge in reporting structures and ETL process because there are so many ways they could be handled. Nulls are considered to be an unknown value, but what does unknown mean? 191 more words

Microsoft Data Technology

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

Combining data from multiple tables:

Note: Microsoft is the owner of the content and video in this blog post.

Microsoft Data Technology