Hi Recently I was working on a data warehouse project and was tasked to generate a date dimension table. Now some of the available options…