Topic: Loss of the data at information sampling
All good afternoon!
I will outline a situation there is 2 floor-mat twist (daily and archive), process ETL preempts the information in txt a file for the subsequent loading on DWH. Sampling of these a floor-mat I twist simple, type:
select * from table1
select * from Arc_table1
To information filling on DWH happens on ( it is read out maximum on DWH, and all that above it gets from a source).
And here during the certain moments there is a following
It should be preempted the table with values
And it is preempted:
DB insulation standard "Read Committed", I assume that the passed lines or were interposed just into this moment but were not in time , and subsequent to them were in time, or probably there was an update of these lines during this moment of reading. More shortly the reasons why so there is I do not know accordingly as it to solve too.
I will be glad to any ideas