Data Sources

SQL Server is the simply the source of the data. A particular database on a DBMS to intake all the data.SQL Server is offered in several editions with different feature set and pricing options to meet a variety of user needs, including the following:

  • Enterprise: Designed for large enterprises with complex data requirements, data warehousing and Web-enabled databases. Has all the features of SQL Server, and its license pricing is the most expensive.
  • Standard: Targeted toward small and medium organizations. Also supports e-commerce and data warehousing.
  • Workgroup: For small organizations. No size or user limits and may be used as the backend database for small Web servers or branch offices.
  • Express: Free for distribution. Has the fewest number of features and limits database size and users. May be used as a replacement for an Access database.
  • Date Dimension Using Computed Columns

    07-May-2019

    Use this script below to create a Date Dimension for a data warehouse that is based off of computed columns. The only column that needs to be populated is the CalendarDate column.

     

    CREATE TABLE [DimDate](
    [DateKey] [int] IDENTITY(1,1) NOTNULL,
    [CalendarDate] [datetime] NULL,
    [CalendarYearNumber] AS (datepart(year,[CalendarDate])),
    [CalendarYearName] AS (CONVERT([varchar](4),datepart(year,[CalendarDate]),(0)))PERSISTED,
    [CalendarQuarterNumber] AS (datepart(quarter,[CalendarDate])),
    [CalendarQuarterName] AS (‘QTR’+CONVERT([varchar](1),datepart(quarter,[CalendarDate]),(0))),
    [CalendarMonthNumber] AS (datepart(month,[CalendarDate])),
    [CalendarMonthName] AS (datename(month,[CalendarDate])),
    [CalendarMonthNameShort] AS (left(datename(month,[CalendarDate]),(3))),
    [DayNumberOfWeek] AS (datepart(weekday,[CalendarDate])),
    [DayNameOfWeek] AS (datename(weekday,[CalendarDate])),
    [CalendarDayNumberOfMonth] AS (datepart(day,[CalendarDate])),
    CONSTRAINT [PKdimDate] PRIMARYKEYCLUSTERED
    (
    [DateKey] ASC
    )WITH (PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON [PRIMARY]
    )ON [PRIMARY]
    GO
    SETANSI_PADDINGOFF
    GO


    WE ALWAYS WORK WITH :