topic Incremental Load without date feild in QlikView

Incremental Load without date feild

lakhansajwan — Tue, 16 Jul 2013 06:47:50 GMT

Can any one tell me how to perform incremental load when there is no date feild but key feild is present?????????

Plz explain with example in case

1) Update

2) Insert

3) Delete..

Re: Incremental Load without date feild

tresB — Tue, 16 Jul 2013 07:15:26 GMT

Unless until you have some timestamp to check for latest updated data, you can't implement incremental load with key field only. Possibly you can handle the Insert Only and Delete Only cases with Key field, but that might not be really incremental.

Re: Incremental Load without date feild

Tue, 16 Jul 2013 07:25:37 GMT

If u dont hv Date field..

Example:

Load

a,b,c

From Source..

Store Example into Example.qvd;

In second time load it will clear old qvd & generate new qvd..

without date it will refresh qvd..no incremental.

Re: Incremental Load without date feild

rwunderlich — Tue, 16 Jul 2013 07:29:37 GMT

Is your key field an ascending value? Does your table have only inserts, not updates?

-Rob

Re: Incremental Load without date feild

Tue, 16 Jul 2013 07:54:01 GMT

Hello,

here are a simple example without a date field.

Not perfect but shows in principal how it could work.

Good luck!

Rainer

Re: Incremental Load without date feild

lakhansajwan — Tue, 16 Jul 2013 08:00:56 GMT

i want to update as well insert and delete in one table

Re: Incremental Load without date feild

lakhansajwan — Tue, 16 Jul 2013 08:02:52 GMT

can i do it with trigger ???????????

if yes plz expalin with example.

Re: Incremental Load without date feild

lakhansajwan — Tue, 16 Jul 2013 09:50:06 GMT

suppose id are not seqential i.e

1 3 5 8 9 12

and then you insert id 2 , how it will work??????????/

Re: Incremental Load without date feild

Tue, 16 Jul 2013 10:18:35 GMT

That does not matter as long as you have a unique identifier. ID. the id's should be ascending. The principle is similar to when you have a timestamp: identify your delta and load them.