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?
Solved
Incremental load without primary key
+4Best answer by Thomas Lind
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.
+7Dear 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
+4Thanks
Obviously it assumes that existing records will never be updated.
+7Dear 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.
+5Hi 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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
