SSIS基础设计最佳实践

ODS表.

必须有的字段. 

[Creationtime] [datetime] NULL,
    CreateTime datetime default(getdate()),

    [DateID]  AS ((datepart(year,[CreationTime])*(10000)+datepart(month,[CreationTime])*(100))+datepart(day,[CreationTime])),
    [HourID]  AS (datepart(hour,[CreationTime])),
    [MiniteID]  AS (datepart(minute,[CreationTime])),
    [IsValid]  AS ((1)),

必须有的变量.

CurrentShortDate,CurrentLongDate, LastSuccessDate, IsOdsFirst

 

 

 

DIM表

必须有的字段

CreationTime datetime,
    DimStartTime datetime,
    DimEndTime datetime,
    IsCurrent int default(1),
    CreateTime datetime default(getdate())

必须有的变量.

CurrentShortDate,CurrentLongDate, LastSuccessDate, IsDimFirst