hi all, I have a job,it read data from MSSQL,and write the data to disk files, I want to incremental updating data,For example:
First write: Name Age test 28 Second write Name Age test 29 because the data is very large, so i don't want to delete the Original file, i just want the data can incremental updating when i write data How can i do this?? Which component i can use?
Hi It's easy to do incremental inserting. Because you can simply record the last accomplished row number and store it for next time using. But for incremental updating, there isn't an accurate way to do this. Especially your description is limited. The most difficult thing is we don't know where to locate the update row. Maybe I miss some details. Regards, Pedro
Thanks for your answer, i query the data first,write them to disk file, i query the data again, i hope i can incremental updating the data when i query data second, for example: first name is test, age is 28, second, name is test,age is 29, when i write data in disk file, the file stored value is test and 29