We have a custom table in R/3. We currently are running a daily delta load based on timestamp from this custom table into an ODS in BW. We now would like to add a new data target that would be filled from this same table (some of the fields to be filled in the ODS are different and don't exist in the first ODS). So, I have one DataSource and 2 Data Targets. This would not be a problem if they both started loading at the same time. The problem I'm having is that the first ODS has been filling daily with deltas and the second ODS is empty. Can I do a delta initialization into the second ODS? Or do I do a full load into the second ODS and then a delta initialization without data and then just pick up on the daily deltas?
ORNL / UT-Battelle