Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have one small doubt. Can we do an incremental load without primary key and Date field?
HI Mahesh,
Yes, you could do for example the ReloadTime() to get the rows that were added from ReloadTime() till now.
Felipe.
You didn't mentioned, what type of incremental load you required.
Insert Only? Insert and Update? Insert, Update and Delete?
The simplest is add-only incremental load. This requires some way of identifying new records - it does not have to be a date-added or date-modified field. If you have a increasing key value, you can identify new records using the key as well.This may be a primary key in the database table, but any continually increasing field value will work.
If you cannot identify newly added records, then add-only incremental load is not possible.
For insert only Incremental Load, you need to have at least one of below
1) Last updated date or any date field
2) Sequential ID
Using above you can identify new records while extracting from the database.
By this, you can create an ID field:
autonumberhash128 (EmpCode, EmpName, Region) as KeyID