Etl, Data Integration, Data Analysis, Data Engineering, Sql.
SOLD column in SOURCE TABLE (updated in SOURCE TABLE) QUANTITY SOLD column in DESTINATION TABLE (not yet updated in DESTINATION TABLE) Change has to be reflected in DESTINATION TABLE. STEP 1 ENSURE THAT SOURCE TABLE HAS NO DUPLICATES WITH NUM_RANKING AS ( SELECT *, RANK() OVER ( PARTITION BY