Dear Friends,
I appreciate your time. I have a fact table with set of transaction values along with 2 date fields. DateKey and InvoiceDate both having the same values. Not sure what to use in my MasterCalendar and also the use of DateKey(Which is not present in any of the dimension tables).
Could you kindly share your ideas?
Thank you again!
Regards,
Kiruthiga