I am trying to load Fiscal Calendar into Teradata. All I was provided was a spreadsheet in the form
Week Start date end date
the spreadsheet has 10 years worth of information in the above format.
I need this
fiscalyear SMALLINT NOT NULL, fiscalquarter BYTEINT NOT NULL, fiscalperiod BYTEINT NOT NULL, fiscalweek BYTEINT NOT NULL, yearplusweekno INTEGER NOT NULL, startdate DATE FORMAT 'yyyymmdd' NOT NULL, enddate DATE FORMAT 'yyyymmdd' NOT NULL
Does anybody know how if there is a better way of doing this?