how to load my data?

adiarnon — Thu, 12 Mar 2015 10:19:44 GMT

hi,

i have a schema with allot of tables, All the table connected with a Key Table,

the schema is reloading every night.

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

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

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

So,

i did one qvw that reload every night and one qvw that reload evey 30 min (with binary for the one in the night)

in the night i reload all the schema with the budget data without the budget rank=0

in the every 30 min i concatenate to the budget the data with the budget rank=0

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

please help

😃

adi

Re: how to load my data?

adiarnon — Thu, 12 Mar 2015 14:10:54 GMT

avinashelite — Thu, 12 Mar 2015 14:29:21 GMT

Hi Adi,

Store the key table in a QVD and every 30mins load the data from QVD and data base . Then compare keytables with the rank and replace it .