I have a Data Source ,loading to a ODS with dialy Delta Loads.
Now for my new requirement, I had created 2nd ODS, for which I have to get Delta loads dialy from the same Data Source.
I m running full load to till date to the 2nd ODS ,and then If i delete Init options to source system for 1st ODS and then if I run INIT With out Data Transfer to both ODS'es and If I run Deltas dialy for both targets, then Shall I get the All Data from the Data Source or Is there any Data probs Occur with this Procedure.
Require your Valuable inputs and the Best way to achieve the same.
I cant delete the data in the 1st ODS as it is critical to the Business for the Reports and it takes many days to load the same.
Thanks in Advance