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

Data is flowing to Change Log table.

Hi Gurus,

I am trying to do a Delta Load from DSO to Info-cube.No data is coming from DSO to Info-cube.The change Log is empty all time although data is been properly loaded.

Can some body give some idea how to solve this problem?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 12:37 AM

    Delta DTP will fetch unloaded requests from the ODS which are not avail in the cube.

    Can you elaborate - what data has been loaded ??

    On Cube Manage - Click on the Monitor for the request in question - Header Tab - Selections - Find what requests have been loaded from ODS.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 12:42 AM

    is ODS request activated?

    Message was edited by:

    zsl05

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 04:30 AM

    1. Create a full data transfer process (DTP) A that reads the data from the A table.

    2. Create a DTP B in the same target.

    3. Use the full DTP A to load data to the target.

    4. In the DTP B, set the processing type to mark the source data as 'fetched' and activate the DTP.

    5. Use the DTP B to load a request.

    6. Set the processing type of the DTP B to the standard type and activate it.

    Alternatively have a look at below OSS-

    Note 1082574 - 7.0 SP 16: First delta load from DSO from active data

    Note 1054499 - 70SP14: DSO extraction does not get the complete delta

    Hope it Helps

    Chetan

    @CP..

    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.