Skip to Content
author's profile photo Former Member
0
Former Member

Moving Data from Change Log to Active in ODS ?

Posted on Nov 18, 2005 at 02:49 PM 14 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2005 at 02:54 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 18, 2005 at 02:59 PM

      Roberto,

      Thanks for your quick reply. Maybe I can be more clearer. First Load of mine was Init w/ Delta, where in Data Selection I had picked from 1-20 and then 25-50. 2nd one was Repair Full request where in Data Selection I had 21-25. This loaded fine but only in Change log as I can't see those in the Active table. So this is where I was stuck wondering how to move it into Active Table so can see all the records together. Thanks for your help on this.

  • author's profile photo Bhanu Gupta
    Bhanu Gupta
    Posted on Nov 18, 2005 at 02:58 PM
    0

    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
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta
      Nov 18, 2005 at 03:43 PM

      Bhanu,

      Thanks for the link. I followed that but the latest request(Repair Full Request) is already activated and I don't see those records from Repair Full along with my First Init w/ Delta request. What I was trying to test is how would I load some records in middle of a range (In this case 21-25) after the initial load has taken place. I was thinking Repair Full Request would do the trick. I loaded my data, although it didn't load in Active and thus wondering what part of the step did I miss out. Pleas advise.. thanks for your time on this.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.