Understanding Transformations: Setup and Renaming Columns for Legibility........READ MORE......
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 ....
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...................
Use the SELECT statement to retrieve a rowset of data from tables and views in a database.. CLICK TO READ --------------
Transact-SQL is an essential skill for database professionals and developers working with Microsoft SQL Server. CLICK to READ -----------------
SSDB ETL - Delete vs Truncate
Tracking Changes Over Time Setup and SCD Type 1.
Incremental Loading with Merge.
Extract Transform and Load using SQL server database stored procedure.
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