topic Re: Incremental Load for QVD big size more than 1.5 gb URGENT in QlikView

Incremental Load for QVD big size more than 1.5 gb URGENT

vikasmahajan — Thu, 06 Feb 2014 10:14:25 GMT

Dear all

I have FACT_GL_Entry_temp_init.qvd which is very big size and while loading I want to take only latest

information old history is maintained in FACT_GL_Entry_temp_init.qvd , Using Incremental load I want to create

FACT_GL_Entry_temp.qvd along with fresh data as well if there change in data from old history data should get updated

I think incremental load will work for this any body have incremental load from QVD and store modified data from historical and fresh data from transactions.

I am attaching my script

Vikas

Re: Incremental Load for QVD big size more than 1.5 gb URGENT

giakoum — Thu, 06 Feb 2014 10:22:07 GMT

is there a unique key identifying every record? if yes, you should use that in a exists function to load only new data. See attached example.

Re: Incremental Load for QVD big size more than 1.5 gb URGENT

er_mohit — Thu, 06 Feb 2014 10:39:49 GMT

@See the attached file