What do we do if we want to do update incremental load to a table that doesn't have its own time field?

ioannagr — Wed, 24 Mar 2021 15:43:20 GMT

My question is basically this on the title of the topic.

I have a table that can be updated, but on its own doesn't have a modification time field.

What do i do ?

Re: What do we do if we want to do update incremental load to a table that doesn't have its own time field?

rwunderlich — Wed, 24 Mar 2021 17:05:01 GMT

If you are using SQL Server, you can add a type rowversion column to the table. That will allow you to easily detect new or changed rows. Other database platforms may have a similar option.

If that is not a solution, could you describe your data a bit more? Is is only new rows you need or changed rows as well? Is there some sort of incrementing record identifier?

-Rob

topic Re: What do we do if we want to do update incremental load to a table that doesn't have its own time field? in App Development

What do we do if we want to do update incremental load to a table that doesn't have its own time field?

Re: What do we do if we want to do update incremental load to a table that doesn't have its own time field?