Dealing with strange scenarios in Incremental Load for our Project.
We have following kind of Data.
ProcessID ProcessDate Metrics Dimensions
1 2016-01-01
2 2016-02-01
3 2016-03-01
4 2016-04-01
5 2016-05-01
6 2016-06-01
7 2016-0701
and so on till December and continued till 2017 Feb
Here, 3,6,9 and 12 means Quarter as in Q1,Q2,Q3,Q4.
1. Scenario 1 ---- I need to show only Months data i.e. 1,2,4,5,7,8,10,11
2. Scenario 2 --- need to show only last Quarter means Q4 of any available Year in QVD it could be 2015, 2016 (history QVD already created) and 2017 data is in database.
