Discussion Board for collaboration on QlikView Scripting.
In my client, it was being requested to the slowly changing dimension, because they will only updathe the excel file once there's a change to any of the records, specifically to its numeric value.
Say for example:
As of 4/1/2012
And as of 6/4/2012
As of 8/1/2012
Note that, this is only one file (excel file)... And excel file will only be overwritten once there's change.
Please help me on this. Your help is much appreciated.
What do you want to achieve.
Do you want to keep the old data with new changed records?
Or you want to only keep new records?
There will be traces, when did the data change its value. So the old must be keep so that I may have historical data.
See one way is you put the Update Date as one of the column, which will be updated once the data is updated.
and then you can use the incremental load logic to get only the changed records.
How to do incremental load logic?
Incremental logic means, you load only those data or records which are updated.
Have a look at the link below for more info on Incremental logic.