loading problem

[adiarnon]

hi,

i have a schema with alot of tables, All the table coneccted with a Key_Table,

the schema is reloading every night.

one of my tables is BUDGET TABLE the budget table have a fieled -Budget Rank.

i need to trancate and insert every 30 min the recorde from the budget table where budget rank=0.

and i need to update my key table (becouse the new records need to connect to all the other tabls)

hope its clear,

what the best way i can do it?

adi

[#2]

Hi Adi,

Since Budget data has to be reload every 30 mins and after that key table has to be updated.

We can try doing this :

While Extracting

1. We write a condition in the script

     if(now() > timestamp(DayStart(Today())+MakeTime(HH,MM))

       and lastreload() < timestamp(DayStart(Today())+MakeTime(HH,MM))

then

    <.........  reload all the script except Budget data.................. >

endif

Store in Qvds

2. We write Budget Data Script

Note:: HH:MM is your daily schema reload time. And step 1 will only execute once in a day, Step 2 will execute every 30 mins.

Store in Qvds

While Dashboard reload

Reload all data in dashboard of QVDs

Also overall scheduling has to be done for every 30 mins in QMC. So budget data will reload every 30 mins, other data will load once a day.

hope its helpful.

[adiarnon]

hi,

tnx bur my problem is diffrent-

i did one qvw that reload every night and one that reload evey 30 min

(with binary for the ond in the night)

in the night i reload the budget data without the budget rank=0

in the everey 30 min i concatanate to the budget the data with the budget rank=0

but my problem is what to do with the key table...

please help

😃

adi

[adiarnon]

someone?

[sasiparupudi1]

Hi

are you still having this problem? please post the sample script so that we can understand the problem better

Sasi

[#6]

HI Adi

I assume your BudgeKey (for rank=0) changes at every reload, but not all BudgetKey

How many records will change in Budget table ?

You have to identify your old key in the KeyTable.

You may add a flag to point out BudgetKey to replace

if only 1 record change it can be easy.

If many you may build a unique way to identify records to replace

Best regards

Chris