ETL Architecture: 02 Create Source Table

最新推荐文章于 2024-03-18 17:59:28 发布

hxp42

最新推荐文章于 2024-03-18 17:59:28 发布

阅读量443

点赞数

分类专栏： SQL Server

本文链接：https://blog.youkuaiyun.com/hxp42/article/details/41745725

版权

SQL Server 专栏收录该内容

12 篇文章

订阅专栏

CREATE TABLE [dbo].[ETLSource](
[SystemKey] [int] IDENTITY(1,1) NOT NULL,
[SourceName] [nvarchar](50) NULL,
[SystemName] [nvarchar](50) NULL,
[SourceDescription] [nvarchar](100) NULL,
[SystemDescription] [nvarchar](100) NULL,
[ETLLoadType] [nvarchar](50) NULL,
[InsertDate] [datetime] NULL,
[UpdateDate] [datetime] NULL,
[RangeType] [nvarchar](20) NULL,
[AcceptMaxRange] [int] NULL,
[DefaultDataRangeStart] [nvarchar](40) NULL

)

CREATE TABLE [dbo].[ETLSourceByID](
[SystemKey] [int] IDENTITY(1,1) NOT NULL,
[SourceName] [nvarchar](50) NULL,
[SystemName] [nvarchar](50) NULL,
[SourceDescription] [nvarchar](100) NULL,
[SystemDescription] [nvarchar](100) NULL,
[ETLLoadType] [nvarchar](50) NULL,
[InsertDate] [datetime] NULL,
[UpdateDate] [datetime] NULL,
[RangeType] [nvarchar](20) NULL,
[AcceptMaxRange] [int] NULL,
[DefaultDataRangeStartID] [nvarchar](40) NULL
)