Hi Manikanta,
Generally the transaction table will have only the transaction date, but in general users expect the Year, Month, Quarter, Week, dates etc to filter the data in the Dashboard, so to arrive this fields we generally use the Master Calendar with all the mentioned fields.
With master Calendar also you can generate this fields by using
LOAD
*,
Year(TransactionDate) AS Year,
Month(TransactionDate) AS Month,
Week(TransactionDate) AS Week,
Day(TransactionDate) AS Day,
QuarterName(TransactionDate) AS Quarter
FROM DataSource;
But people generally prefer to have this fields in a separate calendar. Check below links for generating various calendars
Master Calendar Generation Script
Fiscal and Standard Calendar generation
Regards
Jagan.
.png "Luminary Alumni"){kind=icon}