CREATE TABLE myDimension_temp
AS
SELECT
...
FROM myStagingTable;

RENAME OBJECT myDimension TO myDimension_old;
RENAME OBJECT myDimension_tmp TO myDimension;
DROP TABLE myDimension_old;