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

ODS object - Change table & Active table not consistent


I have an ODS which runs through a delta. This proces has gone through correctly for many years. However I have a situation in which the active table has about 15.000 records and te change log 12 million.

This is wrong. Our Active table should have around 12 million also...

Somehowe the active table has lost almost all records.

Question: Is it possible to repair this without using a full repair from the source?

The extractor is a business content datasource (0CRM_SALES_ACT_1) and is extemely slow. When starting a full load or init on the QA box it loads about 10.000 records each half hour.

Any tips are welcome!


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 09:15 AM


    I believe you can try to load your data from the change log table to the ods itself.

    Is like creating a datasource that reads from a table (in this case the change log table) and then loaded it to the ODS.

    After that you should have everything that exists in the ODS in the change log to the ODS again. Activate it and there you go.

    Also your're loadind everything but not from QA, from BW which should in this case be faster.

    Assign points if helpful.


    Add a comment
    10|10000 characters needed characters exceeded

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.