Incremental loading with two fact tables??

[sushil353]

Hi All,

In my dashboard i have two fact tables... say FACT1 and FACT2.. also there are other dimentions too...

In both fact table there is time_id by which we can restrict the data...

My problem is... first i want to load previous 30 days of data to start with and then data from both fact table should be incremented every 4 hour in 30 days data.

how to make qvd file and store them such that when they are incremented/refreshed successfully i can use them in my dashboard/application.

Pleas help me out to solve this problem..

Thanks...

[#2]

Hi,

Does it mean you always just need last 30 days data in your dashboard and then in QVD?

Chers.

[#3]

Hi,

I think with some modifications to original fileds that you have and taking care in the date format you can try the below script.

//First create a snapshot of 30 days data and store in QVD, this step is one time only.

//Last30daysTranData:

//Load time_id, ctry,prod from table table1 where time_id>=Today()-30;

//

//Store Last30daysTranData into Last30daysTranData.QVD;

//Please uncomment the above code and comment everyhting else to create a snapshot

//Once you created the above snapshot, load data from QVD

//any data beyond 30 days will not be loaded

Last30daysTranData:

Load * from Last30daysTranData.QVD where time_id>=Today()-30;

//this will append incremental data which is not there in above QVD

Concatenate (Last30daysTranData)

Load time_id, ctry,prod from table databasetable where time_id>=Today()-30;

Store Last30daysTranData into Last30daysTranData.QVD;

Cheers.