ETL Architecture: 03 Create ProcessRecord Table

hxp42

于 2014-12-05 11:56:08 发布

阅读量412

点赞数

分类专栏： SQL Server

本文链接：https://blog.csdn.net/hxp42/article/details/41745759

版权

SQL Server 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

CREATE TABLE [dbo].[ETLSourceDataProcessRecord](
[RecordID] [int] IDENTITY(1,1) NOT NULL,
[SourceSystemKey] [int] NULL,
[DataRangeStart] [nvarchar](40) NULL,
[DataRangeEnd] [nvarchar](40) NULL,
[LoadStatus] [int] NULL,
[LoadStartTime] [datetime] NULL,
[LoadEndTime] [datetime] NULL,
[ETLLoadType] [nvarchar](100) NULL,
[ProcessUserName] [nvarchar](100) NULL,
[InsertDate] [datetime] NULL,
[UpdateDate] [datetime] NULL,
[BatchID] [int] NULL

)

CREATE TABLE [dbo].[ETLSourceDataProcessRecordByID](
[RecordID] [int] NOT NULL,
[SourceSystemKey] [int] NULL,
[DataRangeStartID] [nvarchar](40) NULL,
[DataRangeEndID] [nvarchar](40) NULL,
[LoadStatus] [int] NULL,
[LoadStartTime] [datetime] NULL,
[LoadEndTime] [datetime] NULL,
[ETLLoadType] [nvarchar](100) NULL,
[ProcessUserName] [nvarchar](100) NULL,
[InsertDate] [datetime] NULL,
[UpdateDate] [datetime] NULL,
[BatchID] [int] NULL
) ON [PRIMARY]