维度如何进行增量更新

[liangyonglxw]

维度如何进行增量更新?

[liangyong1107]

---使用Except方法没有就插入,具体代码如下
WITH CTE_SYS AS
(
	SELECT 
			 [WarehouseID]
			,[WarehouseName]
			,[WarehouseArea]
			,[ShopBelongTo]
	FROM   tbl_MetaData_Warehouse
	UNION ALL
	SELECT 
			 '未知' as [WarehouseID]
			,'未知' as [WarehouseName]
			,'未知' as [WarehouseArea]
			,'未知' as [ShopBelongTo]
			
),CTE_EXCEPT AS
(
	SELECT * FROM CTE_SYS
	EXCEPT
	SELECT * FROM DataWarehouse.dbo.Dim_Warehouse
)
INSERT INTO DataWarehouse.dbo.Dim_Warehouse
SELECT * FROM CTE_EXCEPT

[OracleFamily]

晕，怎么感觉是自问自答啊