incremental data

[#1]

Hi All

I created a qvd with my data. then i concatenated the qvd with daily incremented data.

it is working fine.  but if i modified my actual data that was not changed in my qvd instated of that i am getting more records on that id.

i know i wrote code for insert condition only.  please help me how to write code for insert update and delete perspective.

id	year	sales
1	5/3/2014	4000
2	6/3/2014	5000
3	7/3/2014	6000
4	8/3/2014	7000
5	9/3/2014	8000
6	5/3/2014	9000
7	1/3/2014	10000
8	6/3/2014	11000
9	6/7/2014	12000
10	4/2/2012	10000

[#2]

Insert update and delete

[swuehl]

Go to http://robwunderlich.com/download and download the QV cook book.

There is well documented example of different kind of incremental loads incl. update contained.

[SunilChauhan]

you need to store back after concatenating then only will reflect in qvd

or

see the attached file

hope this helps