Skip to Content

Delta Mechanism - Source to DSO1 & Further DSO2 load

Scenario - I have DSO_1 in which data get loaded in below sequence .
Day 1 - PO_1 Item_1 Amount_100

After activation of DSO, Active table & Change log table will have 1 record each with 'N' 0RECORDMODE.

Day 2. PO_1 Item_1 Amount_500 #<Key figure value is changed to 500>

After activation of DSO, Active table will have 1 record, change log will have 3 records - 'N' , 'X', ' ' 0RECORDMODE.

Active table -

PO_1 Item_1 Amount_500

Change log table -

PO_1 Item_1 Amount_100 0RECORDMODE_'N'

PO_1 Item_1 Amount_100 0RECORDMODE_'X'

PO_1 Item_1 Amount_500 0RECORDMODE_' '

Question 1 - Now I have created DSO_2 & triggered delta load from DSO_1. how many records will be there in Active table & Change log table after activation of request.

Question 2 - Now I have created Cube_1 & triggered delta load from DSO_1. How many records will be there in cube & what will be value of Amount.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Nov 19, 2018 at 11:34 AM

    Question 1 - Now I have created DSO_2 & triggered delta load from DSO_1. how many records will be there in Active table & Change log table after activation of request.

    if you created DSO_2 after DSO_1 had already been loaded, you should only see 1 record in the active table & 1 in the change log (of DSO_2)

    Question 2 - Now I have created Cube_1 & triggered delta load from DSO_1. How many records will be there in cube & what will be value of Amount.

    same applies as for question 1, value should be 500

    Add comment
    10|10000 characters needed characters exceeded

    • Related Question 1 - yes, DSO_1 was already loaded with 2 requests (Day1 - Request_1 & Day2 - Request_2). On day3 we have created DSO_2 & triggered delta load from DSO_1 to DSO_2. As per my knowledge Delta DTP will fetch all requests (Request_1 & Request_2) from Source DSO considering data mart functionality.

      Active table of DSO_2 - It will have 1 records with final Amount 500.

      Change log table of DSO_2- I am curious about this, as per my knowledge it will have 3 records with 'N','X',' '.

      Change log table -

      PO_1 Item_1 Amount_100 0RECORDMODE_'N'

      PO_1 Item_1 Amount_100 0RECORDMODE_'X'

      PO_1 Item_1 Amount_500 0RECORDMODE_' '

  • Nov 20, 2018 at 08:15 AM

    all 3 request will be picked up from ADSO_1 and sent over, but only 1 request will be in ADSO_2 (unless your datapackages are really small)

    since you load ADSO_2 for the first time, its change log will contain only 1 request...

    Add comment
    10|10000 characters needed characters exceeded

    • Yes Yogen,

      Based on how many data packages you have in your New Table, the change log will be decided.

      Although the final data in Active table will be decided based on keys - 1 record in your case.

      Considering the fact, that you are parallely extracting the data from DSO1 to DSO2, and your DSO1 change log has amount 100 and 500 as part of 2 requests. The New table of the DSO2 will consist of 2 data packages/records, with amount 100 and 500(in your case).

      And when you are activating this it will accordingly insert and update the active table and Change log with first 100 and then 500.

      So overall you will have only 1 record in active table(amount 100) and 3 records in change log(record mode - N, X and '_') in your DSO2.