cancel
Showing results for 
Search instead for 
Did you mean: 

ODS

Former Member
0 Kudos

hello SDN,

1.)

If Full load is loaded into ODS from R/3, does this data get recorded in change log also , assuming no delta init is set?

2.)

And can I subsequently do a delta init from this ODS to a cube? If so, where does this delta come from within the ODS?

For the above, I just like to confirm that my understanding is correct for the 2 situations:

1.) No data is stored in change log in this case.

2.) No delta possible from ODS to cube given that initial loading from source system to staging ODS only contains full load overwrite.

Regards

Suzie

Accepted Solutions (1)

Accepted Solutions (1)

former_member197610
Active Contributor
0 Kudos

HI,

The record will be there in Change Log Table.

You can do delta init to the cube subsequently .

suresh

Former Member
0 Kudos

Thanks Bhanu and Suresh.

So, to conclude, there is no need to delta init into an ODS (only full load in overwrite mode into ODS) if delta is to be reflected in the cube using delta init from the ODS to cube?

best regards

Suzie

null

Message was edited by:

Suzie Fernando

former_member188975
Active Contributor
0 Kudos

Yes, that is correct.

Answers (1)

Answers (1)

former_member188975
Active Contributor
0 Kudos

Hi Suzie,

Even if you are doing a full load from R/3, the activation process will move records to the changelog table. You can subsequently do a init to a further data target.

Hope this helps...