Skip to Content
0
Former Member
Feb 08, 2012 at 06:26 AM

Delta records concept in InfocubeCube

42 Views

Dear SDNer,

I have searched in the forum for beolw concept but i didn't get the proper answer in the forum.

Can anyone one give the adequate explanation for the below scenario.

Scenario : Data loading from DSO to Cube

DSO Data: Yesterday i have loaded the data to the DSO

Customer Calday Status Quantity

1011 yesterday Open 10

the above data is in DSO, i have loaded the data to Infocube.

Cube Data: Yestraday i have loaded the data from the Cube to Cube

Customer Calday Status Quantity

1011 yesterday Open 10

DSO Data: Today i have loaded the data to the DSO

Customer Calday Status Quantity

1011 yesterday Open 10

1011 Today Closed 15

Cube Data: Today i have loaded the data to Cube from DSO.

Customer Calday Status Quantity

1011 Today Closed 15

Final data in the Cube with Quantity 15.

Can any one explain how the delta concept works in Cube by deleting the first record and inserting the new status record.

Please give me some light on this, i have seen some articles on Datasource to DSO/Cube but not DSO to Cube.

Regards,

Satya

Edited by: satya prasad on Feb 8, 2012 7:31 AM