topic Re: How to capture changed status along with date in App Development

How to capture changed status along with date

gopinadhpindra — Fri, 11 Jan 2019 05:06:31 GMT

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

1/11/2019

Inprogress

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

Re: How to capture changed status along with date

zzyjordan — Fri, 11 Jan 2019 06:03:21 GMT

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

Re: How to capture changed status along with date

anilmahanty — Fri, 11 Jan 2019 08:25:13 GMT

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