topic Re: incremental Load from Datawarehouse without having PK and UpdatedDate fields in QlikView

incremental Load from Datawarehouse without having PK and UpdatedDate fields

Tue, 10 Nov 2015 04:46:27 GMT

Dear Team,

currently my Datawarehouse have Updated Field by which i implemented Incremental Load in Qlikview.

for just a knowledge purpose i want to know how can we achieve this when we dont have any Primary Key (PK) and Update fields in datawarehouse.

Thanks

Jitendra Kumar Vishwakarma

Re: incremental Load from Datawarehouse without having PK and UpdatedDate fields

tresB — Tue, 10 Nov 2015 04:57:08 GMT

With none of PK and timestamp - not possible. At least one of them is required. However, only with PK it would be restricted to some basic cases, like Insert, Deletion Only.

Re: incremental Load from Datawarehouse without having PK and UpdatedDate fields

Anonymous — Tue, 10 Nov 2015 05:02:37 GMT

IF you dont have PK or date field, dont think Incremental Load is possible..

If you can to know such solution, post it..

Re: incremental Load from Datawarehouse without having PK and UpdatedDate fields

mohammadkhatimi — Tue, 10 Nov 2015 05:14:36 GMT

Hi...

PFA...