How to deal with incremental load and archiving old data

[david_ze]

Hi,

I have two tables: 'params' and 'sessions' which look like this:

params: id, "param_name", 'param_value" 200m recs

sessions: id, date, action, user_id, user 50m recs

I'd like to load both tables on incremental basis and to hold only 30 days back and put in an archive file (qvd) the data which are older than 30 days.

I will appreciate if you can propose the right script along with example for this.

Thanks in advance,

David

[suniljain]

Params:

Load

ID,

Param_Name,

Param_Value

From Delta.QVD;

concatenate

Load

ID,

Param_Name,

Param_Value

From Historical.QVD where not exists(ID);

in Same manner you can make increamental load for session.

[david_ze]

Do you have a .qvw sample for this?

David

[suniljain]

Dear David,

Chack attached application and reply me if you have any query