Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
I dont have updated date along with changed status,How to capture the updated status changed date please let us know the suggestions on this.please find the data
Yesterday data:
Date | Status | num |
1/1/2019 | Inprogress | 1 |
1/2/2019 | Inprogress | 2 |
1/3/2019 | Inprogress | 3 |
1/4/2019 | Inprogress | 4 |
1/5/2019 | pending | 5 |
1/6/2019 | pending | 6 |
1/7/2019 | pending | 7 |
1/8/2019 | pending | 8 |
1/9/2019 | Closed | 9 |
1/10/2019 | Closed | 10 |
1/10/2019 | Closed | 11 |
Current data with updated status
Date | Status | num |
1/1/2019 | pending | 1 |
1/2/2019 | pending | 2 |
1/3/2019 | pending | 3 |
1/4/2019 | In progress | 4 |
1/5/2019 | Closed | 5 |
1/6/2019 | Closed | 6 |
1/7/2019 | pending | 7 |
1/8/2019 | pending | 8 |
1/9/2019 | Closed | 9 |
1/10/2019 | Closed | 10 |
1/11/2019 | Closed | 11 |
1/11/2019 | Inprogress | 12 |
1/11/2019 | Inprogress | 13 |
Actually i don't have updated status date column in source database here but user want to check the aging of the different status changes,how to capture the updated date along with changed status
Thanks
Hi,
If my understanding is correct, you are trying something like slowly changing Dimension concept.
In this case, use Incremental load using QVD with insert only and maintain an addition 2 column for all the data source table(Incase source system not maintaining).
1. Reload date (DateTime, incase multiple load on same day) -> This will keep track of all record getting loaded
2. Active Record -> To select latest records for unique business column value
ID | Amt | Reload | Active Status |
1 | 100 | 1/10/2019 | 0 |
2 | 150 | 1/10/2019 | 0 |
3 | 200 | 1/10/2019 | 1 |
4 | 220 | 1/10/2019 | 1 |
1 | 110 | 1/11/2019 | 1 |
2 | 80 | 1/11/2019 | 1 |