It is not for auditing purpose
A reader, February 04, 2017 - 7:57 am UTC
Say I have daily accounting huge data .Data is instead via direct sql loader in one table.
On morning end users must be able to view data from bo api.
But often new data are not available in time because of slow load or bad csv file ....
The requirement is to give users the ability to view data of as yesterday or previous load.
Note that we don't have partitioning license.
So how duplicate each load in optimal way in order to achieve requirements?
Note also that the data are from numerous flat files that the total amount of target rows is about 30 millions.
Tkx
February 06, 2017 - 2:59 pm UTC
Well...FDA is *perfect* for that.
It was my mistake to assume this was auditing. The *main* intent of FDA is to be able to provide a view of the data as it was at any point in time in the past.
That is, it lets you run queries like:
select *
from MY_TABLE as of timestamp 'sysdate-1'
etc