Hi Experts,
Need some help. Here is the scenario. I did my first Load into ODS - Init w/ Delta with selections from docs 1-20 & 25-50. (500 records). Then I did a Selective Update for Docs 21-25. Now that loaded successfully in the ODS but I only see those in the Change Log Table. I don't see those 21-25 (about 70 entries) in the Active Log. How would I actually move those records in the active table so can report on those. Any suggestions/pointers will be very much appreciated.
Thanks
I dear,
first of all if you do two inits:
1-20
25-50
then you cannot do another init with
21-25
because is overlapping (25 has been already initialized).
What do you mean by "I did a Selective Update" ?
Anyway, in this case it's better to reload everything again (better if you have all in your PSA)...
Otherwise you can alway build a generic extractor on the changelog table and then reload the missing records (with a full repair request). Or the same but with a file download/upload...
Hope it helps!
Bye,
Roberto
Hi BW Dev,
How do you know that those entries are not in the Active table...have you checked the data values of the Active table, or just looked at the number of rows? Number of rows would not be an accurate indicator as records can be overwritten.
Hope this helps...
Add a comment