Script to create a Month Dimension table which is default to most of the data warehouse development
CREATE
TABLE [dbo].[DimDateMonth](
[YearNumber]
[smallint] NULL,
[MonthNumber]
[tinyint] NULL,
[CalYearMonth]
[int] NULL,
[FiscalYear]
[smallint] NULL,
[FiscalMonth]
[tinyint] NULL,
[FiscalYearMonth]
[int] NULL
)
ON [PRIMARY]
GO
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.