Skip to Content
0
Jul 16, 2014 at 05:43 AM

Problem with Delta Load in DSO

15 Views

HI ALL,

i have a generic data source with cal day as delta relevant field.

if i m taking full load first for example today

i m getting all data.... from PSA--->DSO--->infocube.

key fileds(c1,e1,n1,date,value) psa level

key fileds(c1,e1,n1,date) DSO LEVEL

key fileds(c1,e1,n1,date) CUbe level

but from psa-->DSO level records are like below

c1 e1 n1 value date(psa table)

1 2 1 300 14-jul

1 5 3 600 14-7

1 2 1 700 14-7

c1 e1 n1 value (DSO)

1 2 1 700

1 5 3 600

here in DSO level over writing is taking place.... as a solution i have added one info obj (SNO), this will generate serial number so record can be identified uniquely

sno c1 e1 n1 value date(psa table)

1 1 2 1 300 14-jul

2 1 5 3 600 14-7

3 1 2 1 700 14-7

i have taken this data around 3 30 pm

next day(15-jul) when i triggered delta i got new set of records for 14 -jul

i have got data for 14-jul

in those records few are of same

because of SNO they are not over writing.....

if they over write i ll get 1 rec out of 10 rec....

what would be solution for this....

thanks and regards

vijay