1

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
union all
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
1
2
3
4
5
6
And it is preempted:
1
3
4
6
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 smile
Thanks!

2

Re: Loss of the data at information sampling

-2;
Not  for the reason
Data is preempted 1 time a day at night,  holes will be filled only in a day, and  it is necessary that today the yesterday's data was without gaps.

3

Re: Loss of the data at information sampling

kolyady;
If to preempt not with , and  from tables,  a problem?
.....
stax

4

Re: Loss of the data at information sampling

Stax;
There is an access only on a floor-mat twist, to  access is not present

5

Re: Loss of the data at information sampling

About guru Orakla tell though that , I will be glad to any assumptions why so can happen sad

6

Re: Loss of the data at information sampling

kolyady wrote:

-2;
Not  for the reason
Data is preempted 1 time a day at night,  holes will be filled only in a day, and  it is necessary that today the yesterday's data was without gaps.

Shift the moment of a fence of the data on an overlapping interval.

7

Re: Loss of the data at information sampling

kolyady wrote:

Stax;
There is an access only on a floor-mat twist, to  access is not present

here to advise, those let understand who selected access
To show the passed records, it is empty understand/search that with them not so ( there a sign not to include in I twist)
It is possible  some times ( also in the morning) but where  as for - record time get
It is necessary to find the reason why do not get,  outswapping at night
.....
stax