Datawarehouse - Date dimension

Date Dimensions Generation Articles

MSSQL

https://arcanecode.com/2009/11/18/populating-a-kimball-date-dimension/

https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

http://www.sqlservercentral.com/scripts/Data+Warehousing/156805/

https://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho

Multiple Countries (Holidays and Fiscal Year Info)

** http://www.rad.pasfu.com/index.php?/archives/156-Script-to-Generate-and-Populate-Date-Dimension-Version-2-Adding-Multiple-Financial-Years.html

** http://radacad.com/script-to-generate-and-populate-date-dimension-version-2-adding-multiple-financial-years

PL/SQL Date Dimension

https://stackoverflow.com/questions/28564462/pl-sql-date-dimension-population-of-data-datawarehouse

https://analystarsenal.wordpress.com/2016/11/14/oracle-sql-script-to-generate-date-dimension-data-for-use-in-microsoft-excel-data-models/

http://oracleolap.blogspot.com/2011/01/script-for-time-dimension-table.html

** http://www.oraclenerd.com/2009/03/how-to-populate-your-time-dimension.html

** http://kimballgroup.forumotion.net/t52-date-dimension-in-oracle-with-one-sql-statement

http://www.bradleyschacht.com/date-dimension-script-with-fiscal-year/

https://dylanwan.wordpress.com/2015/10/30/generate-date-dimension-in-plsql-table-function/

https://github.com/dylanwanincorta/Calendar

--Holiday in Date Dimension

https://www.kimballgroup.com/2004/02/design-tip-51-latest-thinking-on-time-dimension-tables/

Consider adding a special row for the unknown date or TBD date as well

Kimball for Time Dimensions

https://www.kimballgroup.com/1997/07/its-time-for-time/