Problem with Deltas

[Former Member]

Hi,

Hope someone can help with the followng problem.

We have had a delta load which was carried out to a DSO but was not pushed to the data mart. The change logs and the PSA have been deleted.

A number of delta loads were carried out after this load but with 0 records transferred - therefore as I understand no repeat delta can be carried out.

Is there a way I can identify the missing records and load them to the Cube?

Thanks,

Leo

Points will be assigned.

[Former Member · Accepted solution]

Hi,

the reason why i want to delete the request from the dso is so that the changes can be passed to the cube. if it remains in the dso then no changes will be passed to the cube.

Sound ok?

[Former Member · Accepted solution]

Hi Leo,

If request is in green(success) then dont delete, for sequence issues.

If you deleted delta request, then repeat delta comes again and over writes existing Repair Full data(may create some data inconsistency)

Hope it Helps

Srini

[Former Member]

Hi,

DSO is set to overwrite and it is a FI Datasource.

I just had an idea we could just do a repair full load for the open fiscal year. Therefore, only the changes would be passed to the data mart. Because the DSO is set to overwrite it wont cause any issues to the DSO data.

I would first delete the data request which did not end up in the data mart though.

Do you agree?

Thanks

[Former Member]

Leo,

No need to delete any request(if u r sure, perticular request not required, then delete). Or simply do repair full with period or year selection.

Push delta from this DSO to futher.

Hope it Helps

Srini

Assigning points way of saying thanks in SDN.

[Former Member]

Hi Leo,

From which datasource data loading...? Loading in addition or overwrite mode...?

[former_member205352]

Unfortunately No.

You need to go for Re Init.

Hope this helps.