Skip to Content
author's profile photo
Former Member

error loading the data into the ODS

Hi,

In BI development, I was trying to load data into the ODS. The data is getting loaded for the first time perfectly. But, from the next load onwards the same data is getting loaded again and again ( I tried to load different data the next time). I think, the data which got loaded into the PSA for the first time is getting loaded again and again. When i try a different load, the previous data which was present in PSA is not getting overlapped. How can i correct this...please help.

Thanks,

Vikki

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:05 PM

    Are u not doing a delta load aft the first laod assuming u hav Initiliazed w/d datatransfer...is the extractor delta enabled in the first place?

    If ur using DTP den do Delta DTP having ur infopackage set up with delta update aft initiliaztion..

    Message was edited by:

    Jr Roberto

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:08 PM

    Are you using DTPs to load the DSO ?

    Is the DTP of type delta or full ?

    A full DTP will bring all the requests that u have in your PSA into the DSO.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:29 PM

    I am using a DTP and I am not using a info package.

    The data flow is as follows

    Data source->tranformation->ODS-> tranformation--->Info cube

    The DTP is of type FULL.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      DTP has to be of type DELTA aft u hav loaded for the first full or jst have Delta even for the first time.

      DELTA DTP will only pick up those new requests frm PSA which dont exist in Cube.

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 10:20 PM

    When i select the option as delta load...i am not able to select the flat file to load the data. Please explain...

    Add comment
    10|10000 characters needed characters exceeded