0 - 2 of 2 tags for dirty read

Hi All,
Please consider a scenario:
A table (contains 10 records) is being loaded with some records (20 records).
It takes 5 mins to retrieve the records from the table.
While User 1 is running a select on the table , in parallel select User 2 runs an insert which inerts 1 records in 60 seconds.

Lot of our jobs needs to wait for some upstream tables that take a really long time to complete. We have some SLA's to be met
for our jobs and are OK with the data as of yesterday in these upstream tables.

Now, the problem is, the upstream tables have logics written as DELETE & INSERT (in the same BTEQ).

delete from DBNAME.TABLENAME
where UPI_COLUMNNAME in
( select UPI_COLUMNNAME
from DBNAME.INCR_DELTA_TABLENAME
)
;

insert into DBNAME.TABLENAME
(
COLUMN1,
COLUMN2
etc.,
)