I’ve some tables in my data source without primary key, but I’ve a MODIFIEDDATETIME field for all the records, that it can be used to incremental load, but TX doesn’t allow it.
Some workaround?
Best answer by Thomas Lind
View originalIncremental load without primary key
Userlevel 3
+1
Userlevel 4
+5
Dear rvgfox,
You can setup a Primary Key Rule in the ODX per connector or define (by hand per table per datasource) for each table the PK and take it from there.
Hope this helps
Userlevel 3
+1
Thanks
Obviously it assumes that existing records will never be updated.
Userlevel 4
+5
Dear rvgfox,
As far as I know this is not yet the case. I know that this idea has been pitched to TX and the R&D team, but i'm not sure if or when it will be on the road map.
Userlevel 6
+5
Hi Ramon
You can run incremental load without PKs if you do not use updates and deletes.
It can give issues in the data area though as there is no checks for double rows.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
