Hi All,
I am having following Incremental scenario.In that I need to drop of min (date) every day in the final QVD
Consider below DB table structure as on 15-08-2015
Scenario:
Date, Value
01-08-2015, 10
02-082015,20
.
.
.
14-08-2015,30
When I am reloading on 16-08-2015 the QVD should creates the following set of data
Date,Value
02-08-2015,20
03-08-2015,30
.
.
.
15-08-2015,100
Basically I need to drop the Min(Date) in QVD in every day refresh