How to capture changed status along with date

[gopinadhpindra]

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

[zzyjordan]

Hi,
What's your expected result? e.g. along the rows, 1/4/2019, 1/5/2019, 1/7/2019,1/9/2019,1/11/2019 should be captured as these days there is a status change comparing to previous?
ZZ

[anilmahanty]

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