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

Delta records Problem.

Hi All,

I have loaded data for a cube in to BiW QA. My full loads for historic data are all fine upto JUNE 2005. I have done an Initialise without data for 01.07.2005 to 31.12.9999, so that I can run daily deltas for current data.

However, my delta is bringing back zero records, even though I know there are 200k records for this period.

I have created new records in Cats R3 QA in order to get the delta to work, but no success. Also, I am unable to delete this initialise load from the info pack. ANY IDEAS?

Question :

1.Shall I put same Selections for init without and Delta?

2. What is the reason for getting zero records?

3. How to solve it?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2005 at 05:19 AM

    hi Sri,

    i think you should not put init without data with selection '01.07.2005' to '31.12.9999'.

    have you delete the init without data transfer request from data target ? any init request should can be deleted from infopackage - scheduler - init option for source system. any error message there ?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      I understood from your first question that you have done full load till June 2005 right, and inorder to capture delta from july 2005 you have done init without data transfer with selections as july 2005-9999 right. (if this is what you have done)and you have said that you had 200K of records does these records r changed records of data before june 2005. if yes---

      you have done full load to previous that 2005 june. but you have done delta init from july 2005 only so the delta pointer is set from july 2005 that means the system will capture delta from this period only, and it will ignore any changes to the previous data without delta initialization, if you have done delta init without data transfer without any selections you would have got all the delta changes what ever the period it is.

      hope i am clear

      thanks and regards


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.