#1097

Changed Users in Load

Before refreshing the dimension, compare the freshest version of each src_id from stg_users with the current row in dim_users. Freshness is determined by latest loaded_at, with the larger id breaking ties. Return src_id values that are present in both tables but differ in name or email, sorted by src_id.

Kampjun tal-output mistenni

Dan hu kif tidher tweġiba korretta — l-għadd tar-ringieli huwa tiegħu stess, m'għandux għalfejn jaqbel mat-tabelli tal-iskema.

src_id
101

Ir-riżultat tal-query tiegħek jidher hawn