I need to extract data from Oracle that is updated 7x24. The records do have an updated datetime, but in some cases they are overwritten as opposed to having new records written out.
The issue is that I cannot figure out a way to extract the data (takes about 2 hours) without a) possibly creating orphan data between the facts and dims, and b)validating back to the source as it is a moving target.
I have been using materialized views but they are taking up too much space in the db...maybe using a trigger?
The issue is that I cannot figure out a way to extract the data (takes about 2 hours) without a) possibly creating orphan data between the facts and dims, and b)validating back to the source as it is a moving target.
I have been using materialized views but they are taking up too much space in the db...maybe using a trigger?