Suppose, If you want update a table based on some other references from other table. In that case, you can go for the below query to update the table.
update z
set z.YearlyIncome = b.YearlyIncome
from DimCustomer z inner join TEMP_DimCustomer b
on z.CustomerKey=b.CustomerKey
Cheers,
Venkatesan Prabu .J