topic Re: Incremental Load without date field in QlikView

Incremental Load without date field

Tue, 21 Oct 2014 12:02:40 GMT

How to implement incremental load in table with no primary key

Re: Incremental Load without date field

Tue, 21 Oct 2014 12:07:32 GMT

What kind of incremental load? Insert Only? Insert and Update? Insert, Update and Delete?

Are you using a Relational Database (Oracle, SQL Server, MySQL) or Text File?

Re: Incremental Load without date field

Tue, 21 Oct 2014 12:21:18 GMT

Hi,

According to my knowledge we need a primary key to develop the incremental load concept.if we don't have primary key then the duplication of data we will get and we can't identify which is inserted and which is updated.

Re: Incremental Load without date field

jonathandienst — Tue, 21 Oct 2014 13:10:35 GMT

If you are doing an update-only incremental load, you need a last updated date or some sequential ID in your source system (so you can identify the 'new' records that you need to extract). For an insert & update scenario, you will need some sort of key in your model to identify the rows being updated.

HTH

Jonathan