摘要：今天的多维数据集又挂了，原因是在Fact_Trade_log表里面有的一条记录在dbo.Dim_User表里找不到相应的属性键！那就只能去业务库查查情况咯。抽取的逻辑是先找出各张表的最大时间戳，然后增量抽取<=最大时间戳的记录--将各表最大时间戳取出--调整顺序以避免出现有交易记录无会员的情况 select @TradeLog_max=cast(ISNULL(max(Timestamp),0) as bigint) from dbo.Trade_Log‘ select @User_max=cast(ISNULL(max(Timestamp),0) as bigint) ... 阅读全文

摘要：declare @BusinessID int declare @MSMnum bigint DECLARE MSMnum_cursor CURSOR FOR select BusinessID,MSMnum from #temp1 OPEN MSMnum_cursor FETCH NEXT FROM MSMnum_cursor INTO @BusinessID,@MSMnum WHILE (@@FETCH_STATUS <> -1) BEGIN update A set A.BusinessID=@BusinessID ... 阅读全文