I want to do a incremental load. I don't have a unique field or date field because in the DB there is only one column(Column1) which contains all the fields. The field inside the Column1 contains some dimensions and a date.
So, is it possible to use row_number() function by taking the time using right function from Column1 and do the incremental load?
