Incremental Load without date field

[#1]

How to implement incremental load in   table with no primary key

[#2]

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?

[#3]

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.

[jonathandienst]

Hi

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