Incremental Load without date feild

[lakhansajwan]

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..

[tresesco]

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.

[#3]

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.

[rwunderlich]

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

-Rob

[#5]

Hello,

here are a simple example without a date field.

Not perfect but shows in principal how it could work.

Good luck!

Rainer

[lakhansajwan]

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

[lakhansajwan]

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

if yes plz expalin with example.

[lakhansajwan]

suppose id are not seqential i.e

1 3 5 8 9 12 

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

[#9]

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.