For updating dimensions we have a lot of update tasks that are similar to:
update a
set
a.UnitofMeasurement=b.UnitofMeasurement,
a.UnitofMeasurementText=b.UnitofMeasurementText
from [Ods].[DimUnit] a
join [Ods].[DimUnitUpdate] b
on a.UnitKey=b.UnitKey
The are displayed as follows in the Dependency Viewer:
However, for sure there is no table [dbo].[a]...
For updating dimensions we have a lot of update tasks that are similar to:
The are displayed as follows in the Dependency Viewer:
However, for sure there is no table [dbo].[a]...