How to do simple Slowly Changing Dimension?

[#1]

Hi,

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

Item No.	Item Description	Agreed Cover
A	Apple	3
B	Blackberry	2
C	Chico	3

And as of 6/4/2012

Item No.	Item Description	Agreed Cover
A	Apple	2.5
B	Blackberry	2
C	Chico	3

As of 8/1/2012

Item No.	Item Description	Agreed Cover
A	Apple	3
B	Blackberry	2.6
C	Chico	2

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.

Thanks,

Bill

[kaushiknsolanki]

Dear Bill,

     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?

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

There will be traces, when did the data change its value. So the old must be keep so that I may have historical data.

Thanks,

Bill

[kaushiknsolanki]

Hi,

     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.

Regards,

Kaushik Solanki

[#5]

How to do incremental load logic?

[kaushiknsolanki]

Hi,

     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.

     http://community.qlik.com/docs/DOC-1870

Regards,

Kaushik Solanki