Hi @god_prophet ,
You can modify your workflow as below,
After data loading, using enrichment reconcile the temp data with targeting schema using reconciliation key.
In Change dimension, select your targeting dimension, And next insert or Update the records.
Parallelly, Query all the records from...