topic Re: Time Stamp in Slow Changing dimension in QlikView

Time Stamp in Slow Changing dimension

narender123 — Sat, 16 Nov 2024 03:27:49 GMT

Hi Team,

I have requirement like slow changing dimension.

Like:

I have a table with 2 fields.

EmployeID, DepartmentName.

1,IT

2,Accounts

After few days the department has been changed for EmployeID=2 from Accounts to Production.Like below

EmployeID, DepartmentName.

1,IT

2,Production

I have to keep the track of both old and new department for employee id.

Please let me know how can I generate the timestamp when ever department for employee changes form old to new.

Thanks,

Narender

narender123 — Mon, 03 Jun 2019 11:24:50 GMT

Any one have idea?

Thanks

Narender

Brett_Bleess — Mon, 01 Jul 2019 18:55:01 GMT

Not sure it is really going to help, but best I have for you, hopefully will give you some ideas:

Regards,
Brett