Synapse TSQL Tip 1 – Use Double Defensive Inserts

When loading a Star Schema Datawarehouse it is very common to need to insert rows into the a dimension based on exceptions. For example: Inferred Members (aka early arriving facts)Unknown Members (missing data) A Typical Query may look something like this for inferred members INSERT INTO DimAccount(AccountCode, AccountName, Inferred) SELECT f.AccountCode, 'Account Missing',1 FROM staging.FactTransactions … Continue reading Synapse TSQL Tip 1 – Use Double Defensive Inserts