I was asked the difference between truncate and delete to test my SQL knowledge for a BI analyst role.
Anonymous
Since when BI Analysts, operating on data warehouses Update, Insert into, Truncate, or delete records? In best case, we drop temporary tables. Seemed irrelevant.
Check out your Company Bowl for anonymous work chats.