Delta Mechanism - Source to DSO1 & Further DSO2 load

[yogen_patil]

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.

[RafkeMagic]

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

[yogen_patil]

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_' '

[RafkeMagic]

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...

[yogen_patil]

You mean Change log table of DSO_2 will have 1 record with 'N'.

Change log table -

PO_1 Item_1 Amount_500 0RECORDMODE_'N' ?

****

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_' '

[shasan]

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.