Export DataSource: delta managing

[former_member185837]

Data loaded in <b>InfoCube 1</b> are currently updated in <b>InfoCube 2</b>, with a <u>delta</u> process.

InfoCube 1    ---->     InfoCube 2

Now I need to load<b> ODS 1</b> also from <b>InfoCube 1</b>, using a <u>delta</u> process as well:

InfoCube 1    ---->     InfoCube2
     |
     ------------>    ODS 1

Is this staging scenario feasible, even though <b>InfoCube 2</b> is <u>already provided with deltas</u> from <b>InfoCube 1</b>? (The scheduler has already got an init loading for that DataSource).

Thanks&Regards, Davide

[Former Member · Accepted solution]

It should be feasible, note that it will probably deliver addictive delta so you'll have to care for this in update rules for ODS

[former_member185837 · Accepted solution]

Hi!

Yes, the one key figure in <b>ODS 1</b> is updated in <i>additive mode</i>.

However I'm wondering which steps & considerations are needed before deleting the initialization from the scheduler (init without data, full repair, etc.).

I don't want to mess it up! I absolutely need to keep working the current delta upload in <b>InfoCube 2</b>!

Thanks, Davide

[former_member184494 · Accepted solution]

Davide,

Create an Init without data transfer for ODS1 and make sure that only ODS1 is selected for the init under data targets and then continue with the deltas for both objects..

Or do a full update into ODS1 and then do an Init without data transfer and continue with your deltas...

Hope it is useful....

Arun

Assign points if useful..

P.S you could also do the init with data for ODS1 and ideally you could also use full update to ODS since overwriting is supported...

[former_member185837 · Accepted solution]

So these are the steps needed - in my understanding:

1) delete the existing initialization in the scheduler;

2) initialize (just!) <b>ODS 1</b>, without data transfer;

3) request a delta, both for <b>InfoCube 2</b> and for <b>ODS 1</b>;

4) continue with the next delta requests for both objects.

Could you please clarify me how the delta process works from a technical perspective? In fact, how can the system know which data is needed during step 3 by <b>InfoCube 2</b> and which other by <b>ODS 1</b>?

Cheers, Davide

[former_member184494 · Accepted solution]

Davide..

The delta from the Infocube would be the same for the IC as well as ODS1 ( but am not too sure how delta is being handled from the Infocube since there is no change log..)

If an Init has been done for the IOBJ - then delta can be done otherwise delta cannot be done - the data would be the same but then it is more of a question as to whether the object has been inited to take further deltas..

Arun

Message was edited by:

Arun Varadarajan

[former_member185837 · Accepted solution]

Hi!

1) Suppose I update the changes from <b>InfoCube 1</b> to <b>InfoCube 2</b>. As a consequence the next delta won't load any record in <b>InfoCube 2</b>.

2) Then I initialize <b>ODS 1</b> without transferring any data. I need to request a delta to load it with some data.

3) Now this very same delta will load lots of records in <b>ODS 1</b>, whereas no records will be loaded in <b>InfoCube 2</b> (see point 1).

I'm wondering how the system can know which records needs to be updated in ODS 1 and which others in InfoCube 2 (none in this case). Is the process supposed to work in this way?

Thank you, Davide