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.
Oodatava väljundi näidis
Nii näeb õige vastus välja — selle ridade arv on omaette ega pea ühtima skeemi tabelitega.
| src_id |
|---|
| 101 |
Logi sisse, et näha esituste ajalugu
Logi sisseLogi sisse, et kasutada AI mentorit
Logi sisse