do someone of you know how to implement Slowly Changing Dimension Type 2 with QlikView Expressor?
My Source is a SQL Server table and the destination is QlikView or more precisely a QVX file. This QVX file is for example the Product Dimension and within this the history should be visible. The Surrogate Key is in this case ProductKey and is handled with Expressors 'utility.sequence()'-function. Maybe also with the start and end time intervall in each record.
Have someone an idea how to implement this scenario?