I want to Insert only Incremental/Changes Records in QVD file. Can I ?

[shantanu73]

Hello Friend's/Guru's,

I want to Insert only Incremental/Changes Records in QVD file. In short I want to update QVD file without dropping QVD file or removing/deleting all

records from QVD file.

This will be useful/helpful went the record is very high say about 1 billion or more. In that case it will be better update the QVD file which will take very

few time to update instead of removing/deleting or dropping QVD file.

I hope I had able to explain scenario.

Thanks in Advance

Shantanu

[Anonymous]

Hi Shantanu,

     i need some clarification,you are asking insert and update condition in qlikview.

Thanks

SHAIK

[shantanu73]

Hello Shaik,

I am want to insert/update/delete recored in QVD file in Qlikveiw without parking the QVD file data in memory. If you go throught the trailing mail I hope u will understand.

Thanks & Regards

Shantanu

[Jason_Michaelides]

Hi Shantanu,

I understand what you are saying about updating the entire QVD file of a billion records taking a long time, however unless you load the whole file, how will you know if an old record needs updating? If you only wanted to insert new records then I would recommend a combination of the solutions above; incremental load maybe creating a small QVD file throughout the day with the hourly loads, then adding to the main QVD file overnight. However, you want to update existing records too which means you need to check the whole file - unless you know more about which records may be updated, like only today's, for example.

Hope this helps,

Jason

[shantanu73]

Hi Jason Michaelides,

In database when we want to update any record we put where clause and then update 1 or 2 columns in table without removing entire row and then add again the required record which has to be update.

Same way are there any possibility of updation of QVD file. Instead for loading whole data in memory then after doing necessary joining process filtering out new & update data and then putting back to QVD file.

The way I am trying to find out the solution because it will be very good while updation or addition of billions of record in QVD file.

Thanks

Shantanu

[Anonymous]

Hi,

  Can you please telme  how you are getting data or frequency of data you are getting  that means are you getting daily basis or monthly basis.

Regards