#1100

Key Count Reconciliation

Before publishing the load, compare volumes: how many unique src_id values arrived in stg_users, and how many rows are currently in dim_users. Return one row with stg_keys and dim_keys.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

dim_keysstg_keys
34

Your query result will appear here