Hi Experts,
I have created Fiscal calendar based on the DOJ(date of joining) and DOL(date of leaving)
Generated the dates(CalDate) From DOJ to DOL for each emplyoyee.
If emplyoyee has no DOL , then generated the dates(CalDate) till today from DOJ
Till now It's working fine.No worries.
But Performence prespective I want to reduce the data
So,
I don't want to load all the dates from DOJ to DOL or till date
Instead of this, load only MonthEND date
For example,
Emp1 has only DOJ(25-Dec-2016)
Now generate the dates from DOJ to till date(i.e 25-Dec-2016 to Tilldate(07-Aug-2017))
As we created calendar we can the dates from 25-Dec-2016 to Tilldate
But here my requirement is
Only Load instead of loading all the dates
25-Dec-2016,
26-dec-2016,
27-Dec-2016.......31-Dec-2016
and
Instead of load all the dates for Jan-2017 load only Monthend date (31-Jan-2017)
Instead of load all the dates for Feb-2017 load only Monthend date (28-Feb-2017)
.........................
For July-2017 Load only 31-Jul-2017
and
1-Aug-2017
2-Aug-2017
3-Aug-2017........till 07-Aug-2017
How to accomplish this?
am sharing my dummy Excel file(which I have exported from qlikview)
Can some one help me out in this??
Awaiting for your response!!!