question

Consultant1-5255 avatar image
0 Votes"
Consultant1-5255 asked MayankBargali-MSFT edited

How to create Time Dimension in Azure Data Factory

I want to create a time fact table on azure data factory with dates ranging from 01/01/2010 to now Thank you

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?



0 Votes 0 ·

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.

0 Votes 0 ·

0 Answers