I want to create a time fact table on azure data factory with dates ranging from 01/01/2010 to now Thank you
I want to create a time fact table on azure data factory with dates ranging from 01/01/2010 to now Thank you
Hi @Consultant1-5255 ,
Welcome to Microsoft Q&A Platform. Thank you for posting query here.
Could you please help on details for below clarifications. So that i can follow along ask and try detailed resolution.
Where you would like to create Time dimension table? Is it in SQL Database?
Are you looking for a table to be created with date column in DB and values ranging from 01/01/2010 to till today?
That means your table will be having only one column which is "date" data type and values in that column will be dates from 01/01/2010 to till today?
Hi @Consultant1-5255 ,
Did you get chance to share details below asked clarifications? Details on clarifications will help to understand ask better and provide detailed resolution. Thank you.
10 people are following this question.